Our product includes several reports written in CR XI. Several of them have date parameters. For example, a Daily Production report asks the user to enter the date he wants the report for. The customer, not surprisingly, wants the default value to be whatever yesterday's date was. The only way I've seen to do that is to have the parameter default to some ridiculous date like '1/1/1900', and the have the select formula check to see if the parameter matches the strange date, and then calculate yesterday's date if it does.
CR lets us write formulas for everything else. Can't we have a "parameter default formula"? We'd just enter a default formula of "DateValue(DateAdd("d", -1, CurrentDateTime)), and voila! Every time the user opens the report, the parameter screen shows yesterday's date!
By any wild chance (he says with no hope whatsoever), does CR 2008 offer that feature?
RobR
Edited by RobR - 12 Jun 2009 at 1:51pm
IP Logged