Print Page | Close Window

Dynamic Parameter - Default Value

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8576
Printed Date: 06 May 2024 at 1:04pm


Topic: Dynamic Parameter - Default Value
Posted By: OKsoccer24
Subject: Dynamic Parameter - Default Value
Date 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?


Replies:
Posted By: OKsoccer24
Date Posted: 07 Dec 2009 at 8:54am
CR XI R2 is the version

Posted By: DBlank
Date 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})

Posted By: OKsoccer24
Date 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.

Posted By: DBlank
Date 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.

Posted By: OKsoccer24
Date Posted: 07 Dec 2009 at 10:38am
Thanks, its crazy some of the flaws XIR2 has....


Print Page | Close Window