Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter default based upon another parameter?

Status
Not open for further replies.

scb1776

Programmer
Dec 29, 2006
31
US
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?
 
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 [wink]



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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?
 
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 [smile])



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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
 
I didn't think they could have this the way that they wanted it. Thanks for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top