SSRS report page error message
I have a page break issue in an SSRS report and I am by no means an expert. This is in the XML label to provide a page break:
<TableGroups>
<TableGroup>
<Grouping Name="AdjustmentPageBreakGroup">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=CInt(Ceiling(RowNumber(Nothing)/28))</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
The page break appears on separate lines in the printed and screen versions of the report:
Print version:
Screen:
As you can see, the print version has a break in the middle of the "Transfer IN" cell, and after the break there is a "Value" on the next page. From what I can tell from the XML, it got a hardcoded page break on line 28 and if I change that number it fixes the print version and breaks the screen version. Is there a way to specify this line break differently for print and screen?
source to share
The solution to this problem is the rectangle component. Based on your image, I am assuming that you have a table in your report that is grouped by location. For each location, you report the quantity and cost. Column 1 is the location name, column 2 is the label, and column 3 is the field values.
Create a new table (TABLE A). Set a table to group by location. In the group footer, add a RECTANGLE. Set the Keep Contents Together property of the rectangle to TRUE.
Add a table to the area of the rectangle (TABLE B). Do not add grouping to TABLE B. Add Column 1, Column 2, and Column 3 to the details row of this table formatted as they are in the existing report.
When the report is displayed, each group will be kept together and the rectangle will force page breaks between groups.
The solution above works for SSRS 2008. The solution below is similar and works for SSRS 2005.
Create a new table (TABLE A). Set a table to group by location. In the group header or footer, add a table (TABLE B). Do not add grouping to TABLE B. Add Column 1, Column 2, and Column 3 to the details row of this table, formatted as they appear in the existing report. In table B, use the Fir table on a single page if possible.
source to share
You can solve this problem using a few small steps:
1-Go to report properties and set the paper size to normal. The width and length should be such that they display the entire column:
2- Then set the Body property similarly:
Now preview the report and download it in any PDF / Any format it won't break:
source to share