Multiple Values in Parameters - Select Expert

[kutoose]

Crystal Reports 8.

Need to modify a report in which an ASP page is passing the parameters to the report. The report has a 'Region' parameter which can have discreet values. Now the logic has to be changed in which the user can select multiple values for region or * for all regions.

How can this be done ? If there are multiple values to region it is passed as commas separated values to the report. I think the select expert has to me modified ...

Thanks !

 

[Madawc]

Do you mean that the user selects a PARTICULAR region or else selects every region.

Do a formula fields, @GOOD_PARAM

Your_Param = "*"
or
Your_Param = {record.region}

Then test for @GOOD_PARAM in your selection statement.

(Note that this is a boolian, a test without an 'IF@ and which will be true or false. You can test @GOOD_PARAM = true, but just saying @GOOD_PARAM impicitly does this.

Madawc Williams (East Anglia, UK)

 

[kutoose]

Thanks for yor time Madawc,

The user can select one region or two regions or n regions or * ( which means all regions)

In the first case the parameter passed to the report is "CA"
if there are more than one parameter passed is
"CA","NY","CT" etc or it can be "*

 

[lbass]

First you should enter "*" (without the quotes) as your topmost default parameter option. Then create a record selection formula like:

if {?parm} <> "*" then
{?parm} = {table.region} else
if {?parm} = "*" then
true

-LB

 

[synapsevampire]

Here's the parameter picklist example:

http://support.businessobjects.com/communityCS/FilesAndUpdates/cr8_parameter_picklist.exe.asp

Note that LB has posted the proper syntax for the record selection, however you need to pass parameters differently using the paramscollection.

-k

 

[kutoose]

Thanks lbass and synapsevampire