LibreOffice Base Any idea to print report data between specific date using forms?

[MicahSpecial]

I have been using query to print report . But what i only can do is printing report one or 12 month for all data user. So is there any way to print and allow user to choose specify date in between for print report for all user in database?

[gkick]

Hi there,

Two options spring to mind. One you can modify your existing query into a parameter query, which will prompt users at runtime to enter a start and finish date.

How do I create a parameter query?

I’m having difficulty in understanding the help on parameter queries. It seems to imply that I can set a “variable” to be used as input for a query - presumably as part of a criterion (at least, that’s how Access worked when I used it decades ago). But the description veers between “variable” and “placeholder” without defining either. I tried (in Query Design) view typing =[date] into the criterion field, but was told that there wasn’t a column called “date”. Adding quotes didn’t help either. T…

Another option is to place a couple of listboxes onto your form feeding selected dates as parameters to the query.

Hope this helps

[MicahSpecial]

Thanks a lot !!