ssrs 2008 page breaks between tablixes

  • I have a new ssrs 2008 report and I am going to have tweleve (12) tablixes for twelve (12) different reports that a user can select on by using a parameter called 'optRPT '.

    The main tablix will be setup by student number. The embedded tablixes are for 12 different reports. I am planning to have 1 main tablix and embed the 12 tablixes within the main tablix .

    The same parameters and dataset will be used for all the reports.

    I want the12 tablixes to to be exported to separate pages and display as separate pages when the ssrs 2008 report is executing. Page breaks will occur between when the student numbers change and when the reports change for each student.

    Should I use conditional page breaks on a single rectangle, a rectangle embedded within a second rectangle, and/or in a table?

    Thus can you tell me what you suggest I try to do to allow the page breaks to occur between when the student number changes and when the reports change for each student?

    Would you show me how to accomplish this goal using pictures, examples, and/or the code that is rquired?

  • What happens if you set a page break after each tablix except the last one?

  • The page breaks appear correctly after each report.

  • Problem solved?

  • No the problem is not solved. There will always be a final blank page caused by the last report selected. No matter if all or if one report is selected there will always be a blank page caused by the page break of the last report.

  • What if you remove the page break on the last report?

  • I removed the page break on the last report. That will work when all reports are selected. However there will be times when the last report is not selected or possibly only one report is selected. In those cases, there will be a blank last page.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply