Rolling year filter on date on a report?

[Triedit]

Hi,

Is there any way that I can put a filter on a date in a report to show only the last twelve months?

I have data going back to 1996 and, although it's no great task, have to keep changing the filter on the dates of most of my reports to just show the last twelve months.

Any help would be appreciated.

Thanks

Annie

 

[Langley]

I recommend that you use qureys to do this. Base your report on an answer table, then do a query for the date range you need before calling the report.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Annie,

Mac's on a good track with this; simply use a script (or button) to run a query that extracts the last twelve months and then open the report on the resulting answer table.

For an example, please see

http://techtricks.com/paradox/btntutor.php

and

http://techtricks.com/paradox/printone.php.

Hope this helps...

-- Lance