October 11, 2013 at 3:13 am
Hi all.
I am new to SSRS and need help with an issue.
I need to display 3 sets of data in a single report.
I have created 3 datasets for 3 tablix
Dataset 1: To display outstanding invoice amount based on 3 critera:
a) From Date
b) To Date
c) Customer name
Dataset 2: To display a single figure - total outstanding amount 2 criteria:
a) As of today's date
b) Customer name
Dataset 3: To display total invoice amount on a monthly basis based on 1 criteria:
a) Customer name
For each tablix, I created a parent group using Customer name and to add a page break.
However, when I tried to display all 3 dataset in 1 report, it will first display the first tablix, then followed by the next tablix and so on.
How can I show all 3 tablix that are grouped by customers?
October 14, 2013 at 6:38 am
Try creating another Tablix and use any of the datasources, and add a group by customer. Then try nesting the original three Tablices inside the newly create Tablix.
October 14, 2013 at 6:22 pm
Hi Tee Time. I tried using nested tablix, but couldn't get it to work.
Anyways, I found a solution and it was quite easy actually. To use sub-report. Hope this will help those new to ssrs (like me).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply