Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Dynamic Parameter - Default Value Post Reply Post New Topic
Author Message
OKsoccer24
Newbie
Newbie


Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
Quote OKsoccer24 Replybullet Topic: Dynamic Parameter - Default Value
    Posted: 07 Dec 2009 at 8:37am
I have dynamic parameters where I add '*' to each prompt.  Is there a way to have the * prefilled for each parameter?
IP IP Logged
OKsoccer24
Newbie
Newbie


Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
Quote OKsoccer24 Replybullet Posted: 07 Dec 2009 at 8:54am
CR XI R2 is the version
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Dec 2009 at 9:59am
I assume you are going for a functional way to select all records (ignore the param).
I do not think you can get any default using dynamic params.
I have added '...All' records to my DB. The '...' portion forces it to be the first in the list (ascending sort) so it gets close to a default and is clearer usage than wildcards for non savvy end users. From there you just write your select statment to account for the '...All" selection option:
({?Param}='...All' or {?Param}={table.field})


Edited by DBlank - 07 Dec 2009 at 10:01am
IP IP Logged
OKsoccer24
Newbie
Newbie


Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
Quote OKsoccer24 Replybullet Posted: 07 Dec 2009 at 10:13am
Right, but your answer is just a different solution to what I already have in place.  In your case, I would was '...All' to already be pre selected so I wouldn't have to worry about filling it in.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Dec 2009 at 10:32am
understood. 
I do not think you can have a default with dynamic params (unless you build a custom interface).
I was trying to give the best alternative I had come up with.
Sorry it is not what you want.


Edited by DBlank - 07 Dec 2009 at 10:33am
IP IP Logged
OKsoccer24
Newbie
Newbie


Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
Quote OKsoccer24 Replybullet Posted: 07 Dec 2009 at 10:38am
Thanks, its crazy some of the flaws XIR2 has....
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.