February 22, 2019 at 9:57 am
I've been looking all over and have not been able to find a solution to this.
I have a report that returns multiple rows of data for a single Job Number. All information displayed is in a JobNum group, so I'm not interested in any of the Detail lines. I have two subreports that I would like to print on separate pages, so a page break at the start of each subreport. The report should thus have a minimum of three pages. I've placed each subreport in a rectangle and set page break before to true for the rectangle. Since I'm only returning one Job Number, placing a break after the JobNum group does nothing. Is there a way to force SSRS to place a page break before each subreport? Just to make it more fun this is a modification of an existing report from our software vendor so I am limited to using existing data for some parts of the report and creating my own subreports for others.
I also can't use a text box Action because I need these to print when I print the report, they go straight to PDF so a user interface is not possible. Any help/suggestions will be greatly appreciated.
John
SQL Rebel without a Where Clause
SQL/Epicor/Prophet21/VISUAL/e.i.e.i.o.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply