New feature request
 Crystal Reports Forum : General Information : New feature request
Message Icon Topic: Parameter default formulas Post Reply Post New Topic
Author Message
RobR
Newbie
Newbie


Joined: 24 Apr 2009
Location: United States
Online Status: Offline
Posts: 18
Quote RobR Replybullet Topic: Parameter default formulas
    Posted: 12 Jun 2009 at 1:50pm
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
Richardson's First Law of Computational Unpredictability: The fact that a given occurrence is impossible does not imply that it will not occur.
IP IP Logged
RichIcicle
Newbie
Newbie


Joined: 06 Jan 2011
Online Status: Offline
Posts: 33
Quote RichIcicle Replybullet Posted: 02 Feb 2011 at 11:22am
I agree that the ability to default report Parameter Fields (static or dynamic) to an initial value other than blank or a hard coded value would be a most excellent addition to crystal reports.
 
I have a report that I would like to default the prompt to the current date.  That could be done with the use of the CurrentDate function in the Parameter wizard's Default Value field.
 
I also want to defaut a username prompt to the current login user.
 
My ultimate objective is having a user press a button and generate today's report without the user having to think about dates or who they are.
 
Thanks for listening,
Rich
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.