I’m working on a report when I encountered a really weird problem,and I can’t seems to find any article mentioning this issue.
The Report have a pretty simple layout that shows every member under each item code,and each item code are in a group that is separated with page breaks.
After previewing the report in SSRS,everything looks completely fine, but when I went on to check the print layout,there appears to be duplicate data showing which mess up the whole report.
e.g when I print the report as PDF, the last member from group item 04 will somehow duplicate a copy and replace the first member for group item 05 which is on the next page,this mess up the report title making it shows item 04 as the title for group item 05,every other part of the report is working as intended with only 04,05 bugging out.
This problem does not happen when I view the report in the preview layout,only when I print out the report as PDF,so I am not sure if the problem is caused by me doing something wrong or if there is something wrong with my SSRS.
Removing the page break for the group for item_code makes it normal,also printing the report as csv or xml which doesn’t includes page break shows the data in the correct layout,printing the report as Excel or PDF breaks it,so I’m expecting that there is something wrong with the whole page break thing that mess up the report when I try to print it.
Vic 917 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.