Parameter Woe's 1

[obtechuser]

I have a report which I have a parameter that allows the user to select 1 or more customer names upon report launch.

I need to give the option to the user to 'Select All' or perhaps bypass the parameter altogether as so the report shows all available customer names.

Theoretically, they can select every name on the drop down of the parameter, 1 by 1, but that would be impractical.

Any help is appreciated.

Thank You,
Marco Sanchez
Crystal Reports 10
Windows XP
MS SQL

 

[IanWaterman]

In Parameter add 'All' to your list, and move it to the top.

In select statement

If {?ParamName} <> 'All' then {FieldName} = {?ParamName} else true

Wrap in ( ) if you want to includeother select clauses.

Ian

 

[obtechuser]

Thank You, this is functioning well..

Question - how does it work?

formula:
If {?ParamName} <> 'All' then {FieldName} = {?ParamName} else true


How does Crystal know to include everything when 'All' is selected.

 

[IanWaterman]

The TRUE at the end of the statement effectively tells the select to include the record.

ie all records become true

Ian