SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
kirru.vrr
kirru.vrr
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
Daniel Bowlin
Daniel Bowlin
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4116 Visits: 2629
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.
kirru.vrr
kirru.vrr
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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.
Daniel Bowlin
Daniel Bowlin
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4116 Visits: 2629
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?
Skylom
Skylom
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search