Q

Modifying reports in Base

Modify OpenOffice reports using imported styles.

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?

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

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close