If the data is huge in each tablix then it will obvisouly cross the page. If data is not that much big in size, please uncheck the Add a Page Break after or Add a page break before option in Tablix properties
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
If your are handling this programmatically then I would suggest merge these datasets programmatically,
now in SSRS report editor create a List object create a group on it using parent key.
Within that list, use text box or any suitable control to display parent details and use a tablix to display child data. Grouping on parent key will automatically sync parent details and child details within that list
Khan_1
Member
5 Points
26 Posts
want to use 3 tablix in a SSRS.
Nov 01, 2012 10:42 AM|LINK
Hi,
I am new in SSRS ,actually i have a situation here that there are 3 tablix in a page.it is ok.
but the issues raising is that in display mode it shows 1st tablix later in last page it shows 2nd tablix & then it shows in lastest the 3rd tablix.
I need to show all the three in 1st page,2nd page,3rd page ...... till last according to their customerid.
ANy suggestion will also be appreciable.
I am using 3 tablix having 3 different sps(datasets)
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: want to use 3 tablix in a SSRS.
Nov 01, 2012 11:25 AM|LINK
If the data is huge in each tablix then it will obvisouly cross the page. If data is not that much big in size, please uncheck the Add a Page Break after or Add a page break before option in Tablix properties
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Asif M. Ibra...
Member
36 Points
10 Posts
Re: want to use 3 tablix in a SSRS.
Nov 02, 2012 06:40 PM|LINK
If your are handling this programmatically then I would suggest merge these datasets programmatically,
now in SSRS report editor create a List object create a group on it using parent key.
Within that list, use text box or any suitable control to display parent details and use a tablix to display child data. Grouping on parent key will automatically sync parent details and child details within that list
</div>