Set default value of parameters?

[robinbowes]

Hi,

I have a couple of report parameters - start_date and end_date - which pop up as prompts.

 

I'd like to set the default value that appears in the prompts so start_date is today - 7 days, and end_date is today.

 

I tried setting the Default Value Expression of the parameter to "date() - 7" but this doesn't appear to have any effect.

 

Is it possible to do what I want?

 

Thanks,

 

R.

[svenn]

Note that the parameter prompt only exist for testing purposes in iReports. They do work outside of the iReports environment.

[robinbowes]

Oh, I see. How do I test them then?

[svenn]

Sorry that should be "They do NOT work outside of the iReports environment."

How do you test what?

 

[robinbowes]

Ah, OK. That makes more sense.

 

Outside the iReport environment, i.e. when I try and run the reports from SugarCRM, the parameters will be provided programmatically.

 

That is, if I can resolve the many other problems I'm having (see my other recent posts!).

 

Thanks,

 

R.

[gabrielinux]

Look up the java calendar class in Google. You need to write a custom function and import the calendar class.