Parameter default based upon another parameter?

[scb1776]

Hi.
I am using Crystal Reports XI and am having a problem with creating the parameters the users want.

The users want two date parameters, Start Date and End Date. The want the default value of the End Date to be the Start Date + 3 months. Is this even possible and if so, what do I need to do?

 

[Turkbear]

Hi,
You may be able to use XIs Cascading parameters for this but, if the users want startdate + 3 months as the end date all the time, why use a second parameter at all? If Not, maybe convince your users that selecting a Date for the End Date is not that hard





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

 

[scb1776]

Thanks.

They want that as the default, but they want to have the option to change it.

I tried to use a cascading parameter, but since I didn't want to choose the value from a table I couldn't figure out how to use the first value in a calculation. Any suggestions on how to do that?

 

[Turkbear]

Hi,
Sorry, I do not - It may not be possible...

('Sometimes users can't always get what they want, but they may find they get what they need' - To paraphrase the Stones )





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

 

[AndrewBaines]

Put a dummy date in as default. Add a comment to the prompt text to say to leave unchanged for start plus 3 months. Then just handle the logic in a formula.
SQL's not as efficient, but you'll get your default date.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[scb1776]

I didn't think they could have this the way that they wanted it. Thanks for your help.

 

[lbass]

Andrew's solution would have worked.

-LB