Frequently asked questions - Base

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

How to make a crosstab query ?

We want to produce a synthesis of a table or query.

The solution will be to use the LibreOffice Calc module that allows to create pivot tables on registered data sources.

Databases can be registered when creating the database or at any time by the menu command Tools ▸ Options ▸ LibreOffice Base ▸ Databases.

Then create a new spreadsheet, run Data ▸ Pivot Table ▸ Create, choose Data source registered option then select items in drop-down lists:

• Name of the database
• Type (table, query , SQL)
• Name of the data source

Complete the layout depending on the desired result.

The spreadsheet can be opened from a form of the database by adding a button to which the properties will be defined :

• Action: Open document/Web page
• URL: select the workbook