Hi everyone, I'm fairly new to ssrs reports. I currently have a series of reports to write. Each report is in a letter format(parent report) with a list of payments(sub report). Each payment has a type, for example "Late Fee" or "Interim Payment" and an $ amount. I have the report built and it works fine so far. What I need to do now though is get the $ amount of a payment, for example Late Fee and use that number in the body of the parent Report. report example: Dear name, Thank you for participating in this program. Your late fee from last year is $amount. This amount has been applied to your fees for this year. Below is detailed payment Interim Payment $$$ Late Fee $$$ Final Payment $$$ Total $$$ I did try to combine the datasets, and then place the field in the text, but it only gave me the first value(Interim Payment) so I gave up on that route. Now I'm stuck. How can I accomplish what I need to do? Thanks in advance.

Hi gswanson, Thanks for the question. My suggestion is using the login user’s account as one filter on the parent report’s dataset, thus the report will return the record just for the current login account. Assuming there is one filed user in the dataset, double-click the dataset in the parent report, click Filters, click Add button, select user in the Expression drop-down list, type in the Value fx dialog box with: =User!UserID. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.