locked
want to use 3 tablix in a SSRS. RRS feed

  • 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)

    Thursday, November 1, 2012 6:42 AM

Answers

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 1, 2012 7:25 AM

All replies

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 1, 2012 7:25 AM
  • 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

    Friday, November 2, 2012 2:40 PM