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.
November 2nd, 2011 3:29am