want to use 3 tablix in a SSRS.

Question

User-240513752 posted

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)

Answer 1

User2105670541 posted

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

Answer 2

User559774174 posted

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