[Solved] Report with variable date

[Nocton]

I want to run a report showing all data entered since a certain date (StartDate), which is recorded in the table as JoinDate. So when I run the report I want it to ask for StartDate and then run the query/report. How is it best to do this? I thought of having a form on which to enter the desired StartDate, but I do not know how to pass the value to the query/report.

Regards, Nocton

[RPG]

Hello

I have not a clear solution for your problem. But maybe this can help you a little
http://www.oooforum.org/forum/viewtopic.phtml?t=131237

Maybe it is enough when you change the 1 to 4
oSingleComposer.appendFilterByColumn(oWorkcontrol.model.boundfield ,TRUE,1)

http://api.openoffice.org/docs/common/r ... rator.html

Romke

[probe1]

in the table as JoinDate. So when I run the report I want it to ask for StartDate

Create a parameter query

Code: Select all

SELECT "name", "value", "JoinDate" FROM "table1" WHERE "JoinDate" >= :StartDate

and set this query as source for the report.
Every time you start the report you are questioned.

Does this help?

[Nocton]

Brilliant, thank you, Winfried. Just what I wanted.

Regards, Nocton