Search code examples
ssrs-2012ssrs-tablix

Position tablix elements at the same position on different pages in SSRS

I have multiple tablixes that are rendered individually on each Excel worksheet when exported. However, I need the position of the tablixes to remain the same throughout all the different sheets, because currently, from the second sheet onwards, the tablix is not in the same position as the first one.

Please help!

Solution

  • What I have done in the past:

    1. You should create the tablix objects with a fixed height and width for better use of assignment.
    2. You should be altering it more on the 'Properties' pane than trying to use the mouse for fixed positions to be more precise. Set the 'tablix' object of my first one and select 'Size' to be 3in, 0.75in for 3 inch width and 0.75 in height.
    3. I would set the 'Location' for the first to 0in,0in. Then using a similar method as 2 for setting a fixed size, start you next one at 0in,(height of first)in. So in my case it would be 0in,0.75in for the next one.
    4. Set the 'PageBreak' > 'BreakLocation' to be 'End' for the first one and every other object you need to break onto a new page. You should NOT do this for the last object as you could generate a blank final page potentially.

    Optional:

    You can name the pages as well that appear under 'PageName' as this names the sheet in Excel as well.