Page break in report

[billg]

I need to create a new page (page break) when a field changes in the detail band. I also need to maintain my header and footer.

example:
-------------------------------(new page)
header

detail = 1
detail = 1
detail = 1





Footer
--------------------------------(new page, ect.)
header

detail = 2





Footer
--------------------------------
header

detail = 3
detail = 3
detail = 3
detail = 3
detail = 3
detail = 3

Footer
--------------------------------
header

detail = 4
detail = 4





Footer
--------------------------------


Any help would be greatly appreciated.

[alexa]

You should receive such a data report as follows:

1. Execute the SQL query, the data report is based on, in a new SQL document.
2. Right-click in the results data grid and select 'Send to -> Data Report...' from the popup menu. Data Report Wizard opens.
3. Leave the 'Standard Report' option selected and complete the wizard.

Please also see the 'Data Report' section in the product's Help documentation and the following material on our website:

http://blogs.devart.com/dbforge/how-to- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html
http://www.devart.com/dbforge/sql/studi ... ivery.html

The 'How to create simple Data Report using dbForge Studio for Oracle?' demo video on the web page for another our product may be also helpful: http://www.devart.com/dbforge/oracle/st ... -more.html

[jrij]

Was there ever any more to this resolution? I need my report to be formatted in a specific manner and am able to group the information the way i want it. However, I am using multiple columns on a single page and do not want the bottom of one section wrapping into the next column. Also, I want each of the largest subset of information to begin on a new page.

Thanks!

[alexa]

Please note that you can achieve this result by setting the 'Page Break' property of the GroupFooter band to 'After the Band', however, you need to set the 'Multi-Column Layout' property of the Detail band to 'First Across, then Down'.

Unfortunately, the current Data Reports implementation can't handle this scenario when setting the 'Multi-Column Layout' property to 'First Down, then Across' since the Data Reports feature of dbForge is based on the third-party component XtraReports supplied by DevExpress and we can't change it.

Please refer to the following suggestions registered in their(DevExpress) Database:

- "Multicolumn - The PageBreak property should be used if Direction(Layout) is DownThenAcross" article which can be found at: www.devexpress.com/issue=AS16590;
- "Multicolumn - The GroupUnion property should be used if Direction(Layout) is DownThenAcross" article which can be found at: www.devexpress.com/issue=AS4668.