Modifying reports in Base
In a Microsoft Access report, I could "keep together" groupings and force a new page. Specifically, in one report with two levels of grouping ("Group" and "Subgroup") I could keep "Subgroup" records together, starting a new Subgroup on a new page, if they wouldn't all fit on the current one. I could also force a new page after each "Group."

How can I do this in OpenOffice's Base?

    Requires Free Membership to View

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

Openoffice.org reports don't offer a lot of control. You can group, but forcing page breaks must be done in the resulting document. You can do it manually with Insert > Break. You can modify the style applied to the subgroup so that it always starts on a new page, or you can modify the table properties (reports are generated in tables).

If you do this using styles, you can save time with each additional report. Create a template with the styles and then import those styles into each generated report. In the generated report, choose Format > Styles and Formatting, click and hold down on the far right icon and choose Load Styles. In the window that appears, select all the checkboxes, then click From File and select the document containing the styles.

This was first published in November 2006

Back to top