Setting a relative default parameter date?

[DKupper]

Greetings all.

I have a report where I'd like to add relative default parameters, but I don't know if it's possible.

What I'd like:

The report has two parameter fields: Start Date and End Date. Generally, Start Date and End Date will be 7 days apart, and End Date will be the day before it's run. However, it can be run for any length of time and any range.

I'd like the defaults to show up as I described - if I run it on 8/6/09, I'd like Start Date to have 7/30/09 and End Date to have 8/5/09.

From what I can tell, the defaults are only hard coded, there's no logic available without using something like VBScript, but I wanted to see if anyone had advice....

Thanks!

 

[Turkbear]

Hi,
Set Default parameters to some obvious 'sample' values ( like 1/1/1600) and test for them to see if they were changed and act accordingly, something like:

If ({?Start Date} = DefaultValue  OR {End Date = DefaultValue )
then
{DateField In (CurrentDate - 7) to  (CurrentDate -1)
Else
{DateField} In {?Start Date} to {?End Date}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[DKupper]

That worked great, thanks!