Repetition of 2 tables in all the pages.

• venkatesh-MSBI

  Mr or Mrs. 500

  Points: 522

  More actions

  June 27, 2011 at 10:27 pm

  #240042

  Hi

  I want to develop a report like below scenario in Reporting Services.

  i have 2 datasets (ds1 & ds2), ds1 will return only one row and ds2 will return multiple rows.

  I need to bind the ds1 values to textbox objects.

  From ds2 some fields can be assigned to one table and some fields to another table.

  Here question is,

  Fom ds2 I need to display 5 rows per page in each table.

  i.e., first table 5 rows & second table five rows

  The ds1 values should repeat in all the pages

  for example: if ds2 is having 13 rows means in first page 5 rows, second page 5 rows and in third page 3 rows plus 2 blank rows with ds1 values in all the pages (which were constant in all the pages).

  Please help me how to achieve this in SSRS.

  Thanks in Advance

  Regards

  Venki

• grrl_geek

  SSC Enthusiast

  Points: 182

  More actions

  June 28, 2011 at 1:39 pm

  #1345457

  Is there a common item the one record from ds1 and the five from ds2 are linked by? If so, have you tried to create a list and group the list by that item? Lists allow you to have more control over how controls are placed.

• venkatesh-MSBI

  Mr or Mrs. 500

  Points: 522

  More actions

  June 29, 2011 at 12:51 am

  #1345665

  I tried with list control also. primary key is common in both the datasets (ds1 and ds2).

  i.e,

  key val1 val2 val3 val4

  ---------------------------------------------

  1 a1 b1 c1 d1

  2 a2 b2 c2 d2

  3 a3 b3 c3 d3

  4 a4 b4 c4 d4

  5 a5 b5 c5 d5

  6 a6 b6 c6 d6

  7 a7 b7 c7 d7

  8 a8 b8 c8 d8

  Here in above ex, we have total 8 rows. Now i have 2 datasets on this result ie., ds1 which will be having key, val1, val2 and ds2 will be having key, val3, val4

  I want to display ds1 in one table and ds2 in another table with 5 rows in each page.

  Regards

  Venki