April 6, 2011 at 9:46 am
Hello.
I have a situation which I’m not sure how to handle.
I have a dataset with clients and their charges for a specific period.
I need to present this dataset in a report but also include also payments for the same period and the payments are associated with the client id but are not allocated to a specific charge. They are just going toward the client’s balance. A client can have 0 to many payments for the same period and 0 to many charges for the same period.
I’d like to present the payments on the report so that each payment is printed on the lines with the charges although it is not really associated with the charge on the same line. In other words, if you change the order of the payments for a specific client that won’t matter.
Is there a way this can be done in SSRS 2008 R2?
Thanks in advance!
OG
April 6, 2011 at 9:52 am
I'd do that in the dataset sql side. I would not waste my time trying to do that in SSRS.
April 11, 2011 at 7:19 am
Easy peasy!
In your existing dataset, join each customer to their payment information. Then create a table with a row group on the customer name, and two columns. Insert rectangles into each column and then a table into each rectangle. Group the left table by the charge id, and group the right table by the payment id; then list the relevant stuff in each table.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply