Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.