In a new ssrs 2008 report, I have one main tablix and will eventually have 18 embedded tablixes. Each embedded tablix represents a unique report that the user can select to have generated.
There will only be one dataset used. This dataset will contain all the columns for all the reports. The first column of the dataset will be report number that is used to distinguish what report in the dataset the datarow is is to be used for. The rows in the dataset will be generated for the report numbers that the user has selected. All the rows in the dataset will be aded to a temp table. This way after all the applicable rows have been generated, only one select statement will need to be used.
The problem that is occurring is a few of the reports are not appearing on their own unique pages. I have set the page break before, page break after and that does not work in all cases. The reports that are having a problem are ones where the detail lines vary based upon the data that is selected. These 'problem' reports each four groupings setup. The reports that have groupings may have a small amount of data to display or they may have a large amount of data to display. Thus the reports vary depending upon the volumne of data that is displayed.
Thus can you tell me and/or point me to url(s) that will tell me how to solve this issue?