Default Value in Parameter Prompt

[deemat]

Hello Everyone,
I am attempting to have a default value shown when a user is prompted to enter a parameter and also when the report is refreshed. For example, when a user has to enter a lastname, instead of the parameter field being blank it shows lastname. Also when the report is refreshed or opened, it shows lastname as the default value and not the lastname that has been searched.

Thanks for all your help

 

[kskid]

From the field explorer, click on the lastname parameter. On the pop-up screen click on Default Value under Options column on the left side and enter ALL on the right column under Settings.

In your record selection, add the following

(
if {?lastname} = "ALL" then
true
else
{table.lastname} = uppercase({?lastname})
)

I use the following for my searches so I can enter a partial last name

(
if {?lastname} = "ALL" then
true
else
{table.lastname} startswith uppercase({?lastname})
)


-lw

 

[deemat]

Thanks but nothing appears in the prompt when the parameter appears, it's still blank.

 

[kskid]

Did you update the parameter settings?

 

[deemat]

Yes, I did.

 

[kskid]

By the way, what version of Crystal Reports are you using? Also are you running the report through an appplication?

 

[deemat]

I'm using version XI and but not through an applicaton.

 

[kskid]

Try creating another parameter with a default. If successful, then delete the original and recreate it.

 

[lbass]

In XI, I believe the defaults will populate the list only when you open a report that is saved without data. After running the report, if you want to run it again with new values, the selections from the previous run will automatically appear in the selection boxes for you to change to the new values. I don't think there is a way to change this.

-LB

 

[deemat]

Thank you both for your responses. I will try something different since its no way to change the values.