Parameters - Multiple Values for one Label - Possible?

Is it possible to have a parameter with one label but multiple values. For example:

Label Value

Machinist (100,200,300)

Is it possible to set up an expression that when the user selects this label it will look for the job codes 100, 200 and 300

and return all employees in those codes?

Thanks,

A

No, but what you can do is this...

Create the viewable parameter (We'll call it Parm1)

Create a 2 column SQL table that contains your cross references (We'll call that tblXRef)

in this case tblXRef would contain 3 rows:

Machinist, 100

Machinist, 200

Machinist, 300

Create a dataset that uses the following SQL:

Select Type, ID from tblXRef Where Type = @.Parm1

(Call this dataset Lookups)

Create another parameter (We'll call it Parm2), set it to Internal, Multi value, and set the source = Lookups and the fields = ID

Set the Default Values to Lookups, ID.

In your main SQL dataset, use the Parm2 parameter to do your filtering.

HtH

BobP

|||

Not sure how big is the list but can make a dataset like this and set the paramters -

Select 1,'Machinist-100' As Machinist-100
Union
Select 2,'Machinist-200' As Machinist-200
Union
Select 3,'Machinist-300' As Machinist-300

Hope this helps someway.