How to repeat the two tables in each page of ssrs report

  • Hi

    In my report i created two tables with same dataset.

    second table contains multiple rows.so am showing the second table data based on number of records per page(For this i created a group, and the expression is int((RowNumber(Nothing)-1)/1) and checked the 'page break at end').I achieved this.

    But the first table is appearing in the first page only.But i want to repeat the first table data should repeat in every page.

    Is there any solution??

    Thanks in advance

  • Can you give a little more information please?

    Why do you need 2 tables from one dataset?

    What on the first table do you need to repeat on every page?

    Pictures and sample data might help.

  • Hi Daniel,

    sorry i want tables with different datasets.

    For example,

    two datasets are there Department,Employee.

    In the Report,for first report table i want show department details.

    In the second table i want to show the employees belongs to that department.

    so,in this way i want to show both department and employee details in each page.

    This is my requirement.

  • OK, then I have to assume there is a relationship between the employee and the department. Why not create one dataset and then do a report that shows employee detail with a grouping by department?

  • Hi,

    I have the same problem.

    I have table1 with dataset1

    and table2 with dataset2.

    My table 2 is on several pages and my table1 has 3 or 4 rows.

    So, i have to repeat my table1 on each page.

    I tried Advanced mode and set "RepeatOnEachPage" property but it doesn't work.

    Do you have a solution to do it?

    Thanks in advance.

    PS : Sorry for my english

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply