I am a newbie to CR9. I have some reports that have a Data_Range parameter that is entered when the run it. Date start, date end. How can I change the report to automatically enter the past 7 days (or weektodatefromsun type) as the range.
Thanks in advance
It won't default to specific values if that's what you mean.
You can however set permanent default values and if the user doesn't change them it will default to the last week.
The record selection formula->record would then read:
//assuming a default value of 1/1/1970
(
if {Datestart} <> cdate(1970,1,1) then
{table.field} >= {?Startdate}
and
{table.field} <= {?Dateend}
else
if {Datestart} = cdate(1970,1,1) then
{table.field} >= currentdate-6
and
{table.field} <= currentdate)
)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.