How to use the upper & lower bound in reports

Hi,

I need to pass the start date & end date to a report, but the report is sorted by user id +date+time.

How to use the upper & lower bound in the report so that it knows to only show those records within the start & end date range ?

Regards,

PETER ZHOU

Peter,

Possibly you could construct a seperate query, sorted on date, to read the first and last dates to variables, prior to running your report query. You could then constrain the display of your report data by these predertermined variables?

Milton

Hi Peter,

For both report based on a datafile and based on a query you can define the sort and selection to be different. So the sort order does not necessarily have to be the same as the upper and lower bound. Define the start and end date to be parameters for the selection and define the sort for other items (user id +date+time). This is all quite easy with the query wizard.

Regards,
Piet