Ordering of tables in a Report
Hello,
I have the following situation:
A report with three different tables. Each table has a respective dataset associated with it.
Each table has a grouping condition on it. This grouping condition is same on all the tables.
I would like those tables to appear in certain order obeying the grouping condition.
For example:
Table1, Table 2, Table 3 have datasets DS1, DS2, DS3 and grouping conditions C1, C2, C3.
C1 = C2 =C3.
I want first record of Table1 on page 1 followed by Table2 on page 2 followed by Table3 on page 3 .
second record of Table 1 on page 4 followed by second record of Table 2 on page 5 followed by second record of table 3 on page6
and so on.
October 31st, 2011 1:09pm
Hi namrataghadi,
What is the relationship among the three dataset?
If they come from the same source table in SSMS or they have one-to-one/one-to-many/many-to-many relationships, I suggest you to merge the three datasets into one with
Join or
Union.
And then, using the List component in BIDS to achive it as:
http://social.msdn.microsoft.com/Forums/ar/sqlreportingservices/thread/3593b2db-21c3-4eb5-9657-cbbc6b668acb
Thanks,
Lola
Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2011 3:29am