[Solved]Report Query Builder

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved]Report Query Builder

Post by gkick »

Hello all,

Is it possible to create some sort of query builder using a form, i.e. have a form with several list boxes to specify multiple criteria aka for example in an asset table, select owner, select department, select brand, etc and have a button to run a report based on the underlying filter table without actually showing the data in the form which only serves the purpose of nominating one or multiple criteria, which means if no selection is made from listbox1, it defaults to all in the filter table?
Anyone having an example of something similar?

Thks
Last edited by gkick on Fri Feb 14, 2020 3:27 am, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Report Query Builder

Post by Villeroy »

Search this forum for "power filtering" and this in depth tutorial [Example #1] Filter/Search with Forms (leveraging SubForms)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Report Query Builder

Post by gkick »

Thks ;)
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Post Reply