Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to repeat the two tables in each page of ssrs report Expand / Collapse
Author
Message
Posted Wednesday, August 10, 2011 12:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 10:39 PM
Points: 9, Visits: 172
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
Post #1157414
Posted Thursday, August 11, 2011 7:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 7:35 AM
Points: 2,817, Visits: 2,563
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.
Post #1158437
Posted Friday, August 12, 2011 12:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 10:39 PM
Points: 9, Visits: 172
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.
Post #1158976
Posted Friday, August 12, 2011 7:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 7:35 AM
Points: 2,817, Visits: 2,563
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?
Post #1159187
Posted Thursday, July 11, 2013 10:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 11, 2013 12:31 PM
Points: 1, Visits: 14
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
Post #1472679
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse