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
[Solved]Report Query Builder
[Solved]Report Query Builder
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
Re: Report Query Builder
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice