Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to do a Dynamic Filtering on LibreOffice Base Reports?

share|improve this question
What is dynamic filtering ? – Simon Sheehan Nov 8 '11 at 21:03
up vote 2 down vote accepted

Yes. If you are using the default database type. Build the table on a query with parameters. That is, if you have a table T and want to filter on a field A in the table, set up a query like this: SELECT * FROM T WHERE A=:parameter

You will be prompted for the parameter when you open the table. Only matching records are printed.

You can even include the parameter value in the table, at least when using the libreoffice report builder extension

share|improve this answer

could be possible to use a dummy like

SELECT * FROM T WHERE A:=parameter (OR A=anyregister IF they pres RETURN without write anything)

The idea is ask a lot of parameters to the user, and the user decide what parameters must be used

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .