LibreOffice Base Report Builder Features

LibreOffice Base includes a comprehensive, built-in Report Builder that was originally an external extension but is now fully integrated into the standard installation. This article details the core features available by default in the Base Report Builder, including visual design tools, advanced grouping, dynamic calculations, chart embedding, and flexible output customization.

Visual Band-Based Design Environment

The standard Report Builder provides a full WYSIWYG (What You See Is What You Get) visual canvas structured into modular bands. Designers can place controls and format data within distinct horizontal bands: * Report Header and Footer: Displays information once at the very beginning and very end of the entire report (e.g., titles, summary metrics). * Page Header and Footer: Prints at the top and bottom of every generated page (e.g., column headers, page numbers, run dates). * Detail Section: Repeats for every single record returned by the underlying query or table.

Multi-Level Grouping and Sorting

Reports can be structured hierarchically based on one or more database fields. * Custom Group Sections: Adding a group automatically introduces dedicated Group Header and Group Footer bands. * Sorting Control: Data can be sorted in ascending or descending order across multiple levels independently of the underlying SQL query. * Keep Together Properties: Controls whether a group or section must remain intact on a single page to prevent awkward page breaks.

Dynamic Calculations and Functions

The Report Builder includes an integrated function engine for data aggregation and calculated fields without requiring manual SQL editing. * Standard Aggregates: Built-in calculation options include Sum, Count, Average, Minimum, and Maximum. * Running Totals: Computes cumulative values across groups or throughout the entire document. * Custom Expressions: Supports formula syntax to concatenate text fields, manipulate dates, or execute logical expressions.

Conditional Formatting and Styling

Data presentation can be dynamically altered to highlight key metrics: * Conditional Visibility: Elements can hide or display based on specific record values. * Style Overrides: Text colors, background fills, and font weights can change automatically when defined conditions are met. * Precise Control Positioning: Precise control over snap-to-grid, alignment, borders, and margins ensures pixel-perfect printable documents.

Chart and Image Integration

• Dynamic Charts: Users can embed charts that visually represent summary data generated directly within the report context.
• Bound and Static Graphics: Supports static logos and watermarks, as well as binary/BLOB image fields stored directly inside database records.

Document-Based Output

Because reports in LibreOffice Base compile directly into standard OpenDocument Text (.odt) documents, users can further edit, annotate, or export the resulting reports to PDF and other common document formats with complete fidelity.