I have created a Matrix report. In the matrix report I have limited the report columns per page.
For example, I have limited the number of columns per page to 6. I therefore have 12 columns over 2 pages. I need to insert one more column after 12th column (13, Cost), and to only display this on the second page of the report, not as a last column of every page.
Note: I need to add the "Cost" as last column on last page for the column group.
From the image the columns 1,2,3,4 want to display on last page only.
My report design
Click here to view the report details
Can anyone please help me with this. Thanks in advance.
I don't really get what you're trying to achieve exactly because usually tables grow vertically, as in rows get added, which could cause your report to grow in pages. Making it extremely difficult to determine what is the last page of your report.
To solve your problem you could simply create a second Tablix which contains only the columns that you wish to display on the last page. And remove those columns from the first Tablix. This will also make it a lot more easier to determine when to add a page-break.
Using expressions (combined with rectangles for example) you could do a lot more grouping and manipulating of the layout. Unfortunately I don't possess enough information and details to give you more accurate advise but you're always welcome to update your question if you need any more assistance.
What you're trying to do in point [2.] of your comment is simply not possible with the reporter. There is no way to determine on which page you are leave alone the exact position on that page.
The only way I know how to calculate this accurately is by keeping track of the exact row's nummer you're at aswell as the amount of rows that fit on a page. Needless to say that this is an extremely tedious and troublesome, especially if the columns aren't fixed either.
Using the column grouping as you say in point [3.] might be possible but have to share the expressions you used for divide the table and the column grouping to be certain. And even then it'll be a complex expression to force this kind of behavior.
However, I believe you could use my first suggestion and change it slightly based on your new description. Instead of creating a new Tablix below, you could place him next to your first table. This new tablix then only needs to have 1 column, the extra column you're trying to add.
If there is enough space on the last page to place this column next to the last column group, then it will be placed exactly where you want it. This of course won't work if you don't have enough horizontal space on your page, then it'll simply get printed on an entire new page.