We have built a custom Job Traveler that is a copy of the standard SSRS report and uses the default RDD. What we changed was the format from landscape to portrait and we added the material requirements at the operation level as well as the top-level BOM. The operation level material requirement is a duplicated RawMaterialRequirement subreport with an additional parameter for oprseq.
Situation
The report prints fine if the added subreport is set to hidden. But if the subreport is shown we get duplicated pages and blank pages.
Needs
I need a way to diagnose what is going on with this subreport, and why it seems to demolish the report.
I have tried resizing both the subreport and the main report, adding in blank lines between the end of the main report and the subreport, and page breaks before and after. None of these actions have helped with the blank and repeat page problem. has anyone else had this issue with a report before?
Make sure the Subreport width is not too big. Subreport page width needs to be shorter than the width of the Subreport rectangle on the parent RDL. Make sure to look at all the margins settings too.
@cfinley,
The repeat is at the operation’s Scheduling Resources. If the added RawMaterialRequirement2 subreport is hidden all is well. If the subreport is shown then it splits the Scheduling Resources section where the resource group and resource description is. This happens whether the data goes all the way down the page or only halfway. Then a duplicate of that operation is printed on the next page, but in the scheduling resources section, only the description is shown.
Here is a doctored pdf of pages 8 9 and 10 that show the duplication issue. Traveler with Error.pdf (81.8 KB)
@TomAlexander,
The report is set to 8.5 x 11 with margins both the main report and subreport are 7.75 inches and have a 0.15 inch margin. The subreport rectangle is the same way.