I created a report in Visual Studio 2012 that has two report definitions. The main report section repeats once per vehicle, and it has a subreport that repeats once for each delivery that vehicle has.
The main report design looks as follows:
The orange bar on the left side indicates that the rectangle on which I have all the other elements located is selected.
I have set the following properties on it:
I have also set Add a page break before
and Add a page break after
on the Tablix that contains the other elements:
There is no other Rectangle or Tablix on this report design.
My problem is that it doesn't always do a page-break before and after. On pages with only a little information, it puts each vehicle on the same page, as follows:
But when a vehicle is longer than a single page, it spills into the next page, and the next vehicle does not add a page break before it, like so:
How can I force the report to always insert a page break before a new vehicle?
Maybe these links could help you.
Goodluck!
Update by original poster
Reading all the instructions on the previous pages, I found the a solution. My main report tablix needed to be grouped into individual rows, and those row groups needed page breaks.
To add a page break to a grouping in a table
Row Group
submenu, and then click Group Properties...
.General
tab, add a Group on
expression. In my case, it was VehicleID.Breaks
tab, click Between each instance of the group
OK