Select date ranges at print

[Guest_imported]

Would like to have a drop down list of date ranges to choose from when report is selected to preview or print.
ie: Month to date, Year to date, 1st qtr, 2nd qtr etc.

 

[dcm]

LWarner: I suggest that you create a string parameter whic you can then populate with just the terms you listed. This would enable you to then use a formula field to select data along the following lines:

if Instr({?parameter},"Month to date&quot>0 then Date in MonthToDate else
if Instr({?parameter},"Year to date&quot>0 then Date in YearToDate else
if Instr({?parameter},"1st qtr&quot>0 then Date in Calendar1stQtr else
if Instr({?parameter},"2nd qtr&quot>0 then Date in Calendar2ndQtr else
........

All of these functions work based upon either Currentdate (i.e. today's date) or PrintDate (I prefer this one as I can then set the date of the report to some other date)

Hope this helps David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner