page-break in master-detail

[sergiord2016]

Hello everybody , i have made this master detail



I want to make a page break for each master data

Also if it is possible i want to not show the master header if no detail data is avaliable , for example this case i don't want to show C.S. BRUJULA because it dows not have any detail data:



Thank you in advance ,

[rockytopmark]

Use Page Sets for the Master to get your desired page breaks.  To eliminate the no data pages, set the filter on the query you use for the Page Sets to only return records that have at least 1 detail row.

To add a Page Set:
1. Click Page Explorer and select Report Pages
2. From the toolbox, click and grab Page Set and drag it into the Report Pages pane
3. Click and Drag your existing Page under the detail folder of the new Page Set
4. Click on the Page Set and assign it a query, that as mentioned above, will produce only the Master values with at least 1 row of data
5. Set the Grouping and Sorting property for the Page Set to the desired item

[sergiord2016]

Thank you for the answer , i did all that but the pages does not break for each master data.

Two or more master data are palcede in the same page...

[rockytopmark]

You may need to remove the master section from the report page, and in-turn lose the existing Master-detail relationship.
Then, create a new master detail relationship between the list query and the page set query.
Create a new text item above your list that is sourced from the Page Set query.

[New_Guy]

Hi,
Did you try placing a singleton(available in toolbox) and then place the page set grouped item in the singleton. Is it relational or dimensional report?
Good luck
New guy

[rockytopmark]

I have attached a simple page set example using the Go Data Warehouse (query) package.

No singleton is necessary.

Report uses 1 query... same for Page Set and List.  Page Set is grouped by Order Method type, so we get a new page for each Order Method.

[sergiord2016]

thank you all for your replies