Change record name for a parameter select

[timmahan]

Using CR XI

I have created a parameter for the user to select either New or Used from the field {sales.newused}, easy enough.

However the data field contains either "U" or "N"

How can I change or replace the "U" or "N" with "Used" or "New", so the the user can type in New and get N or type Used and get U ??

 

[IanWaterman]

Best to set up parameter so that user can only select New or Used. Other wise you will run into case issues.

In select satement add following

(If {?Param} = 'New' then {sales.newused} = 'N' else {sales.newused} = 'U')

Make sure its in brackets so can be used with other conditions.

Ian

 

[Madawc]

In Crystal 10, you can add a description to your default values. A button called [Set Description] in the default values pane.

There's also a 'radio button' on the parameter details that lets you allow or prevent the user entering their own values. If you enter every valid choice you can prevent the rest.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Set up the parameter to use the field values (N, U) for the value and "New" and "Used" for the description fields. Then set the parameter to display only the description field. In your formula you would use:

{table.newused} = {?Parm}

-LB