SSRS page break after line with subordinate (in rectangle)
I spend hours looking for a solution for something "simple". I have a report (SSRS 2008 R2) with a table with rows grouped by saleslineid. For each trading line, I want to show a sub-report with the specifications and then the components of the trading line. But I want the component list to run on a new page.
For example:
SPECIFICATIONS:
Object A
Brown color
Height 200
- PAGE BREAK! -
LIST OF COMPONENTS
Product description
100 COMP1
101 COMP2
etc.
As you can see in the picture, I placed my subreport in a rectangle and set PageBreak - Breaklocation to End.
Tried it with a string inbetween with a rectangle. Read about 100 pages with more or less similar problems, but I can't get it to work?
Can this be done?
Respectfully,
Mike
source to share
I didn't find a way to solve the page break rectangle issue, so I decided to add one additional line type and one additional entry to my query using UNION.
eg:
Select 1 as linetype, A.SalesId, B.SalesName
UNION
Select 0 as linetype, A.SalesId, NULL as SalesName
In the UNION query, I am missing fields that I really don't need in this section to read everything.
With this new group I can force a new page and I hide the lines in my tablix based on the line type
What I don't like is that my already hard-to-read sql query doubles in size, but it does the job.
source to share
It can be done, but for clarification, is this your layout? Should it look like this in your subheading?
- function
- Components (this is on another page)
If yes, then you include all BOMs in a rectangle, then define PageBreak -> BreakLocation to End
Or
Close all components in a rectangle, then define PageBreak -> BreakLocation to Start
source to share
I fixed the issue which is this: Page break in local testing order, but not working on report server.
My report structure:
- Tablix
-- Rectangle (page break here)
--- Sub-report1 with visibility expressions
--- Sub-report1 with visibility expressions
Then I tried to change the structure:
- Tablix
-- Rectangle (page break here)
--- Rectangle1 (another rectangle level)
---- Sub-report1 with visibility expressions
--- Rectangle2 (another rectangle level)
---- Sub-report2 with visibility expressions
And it fixed both url loading and viewer.
I hope this helps someone who is struggling with this.
source to share