Date dependant report (1 Viewer)

gilescis

D. Castaldo
Local time
Today, 01:20
Joined
Jan 23, 2006
Messages
106
I have a report that pints by date range selected. However, instead of putting in the date range, I would like to run the report and let the user select only the month, then print data for that current month.

Example.
field= startdate
If the start date is 10/1/2011
I want the user to be prompted for the current month ie.. 10 and it give me all the data from 10/1/current year to 10/31/currentyear

Thanks for any help in advance
D.Castaldo
Clyde Fire Department
 

kevlray

Registered User.
Local time
Yesterday, 22:20
Joined
Apr 5, 2010
Messages
1,046
You can put in a numeric prompt. Then in the selection criteria {datefield}>=(date(Year(currentdate),{?Month},01)) and {datefield}< date(Year(currentdate),{?Month}+1,01). I have not tried this, but believe it will work. FYI: Not sure what version of CR you are using, but see if you can set a minimum and maximum values.
 

Users who are viewing this thread

Top Bottom