Search code examples
reporting-servicesrdl

SSRS Report Multiple Pages Tablix Order

I'm using ReportingService 2010 and im trying to get multiple reports into one file on sperate pages. The problem is the order of the pages.

At this point I have a table for each of my datasets on seperate pages. Export to Excel works great, but the order of the pages (Web View and Excel Worksheets) doesn't match the order of my Tablix elements of the rdl file.

Setup is like:

    ..
<DataSets>
    Dataset Name="A"
    Dataset Name="B"
    Dataset Name="C"
</DataSets>
    ..
<ReportItems> 
    <Tablix Name="A_Tablix">...<PageBreak><BreakLocation>End</BreakLocation></PageBreak></Tablix>
    <Tablix Name="B_Tablix">...<PageBreak><BreakLocation>End</BreakLocation></PageBreak></Tablix>
    <Tablix Name="C_Tablix">...<PageBreak><BreakLocation>End</BreakLocation></PageBreak></Tablix>
</ReportItems> 
...

But the pages seem to appear like random, and not in the order of the rdl file. Is there any element I'm missing? Or how do I have to order the Tablix elements of the code to get the same order in the Web View and Excel Worksheets?

Solution

  • I found the answer, after some experimentation...

    The problem was, that the Tablix were overlapping. They started at Top 0 and Left 0. It works as expected, after I added an offset according to the desired position to the Top value like: x*Height of Tablix