• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

Limiting the number of Range of values used by a parameter

I have a parameter that allows the user to select multiple employee numbers.  As an example it shows all employees from employee #1 to employee # 100.  However all direct employees are are numbered from 1 to 50, contractors are 51-100.  Right now they can pick any employee through 100.  I want them to only be able to run the report on contractors.  How do I set it up so that they can only select employee #s > 50?  More direct - how do I filter a parameter list?

Thanks,
0
soarhigher
Asked:
soarhigher
1 Solution
 
mlmccCommented:
I am not sure that you can.

You could try using a Command for the list like

Select EmpNumber From EmpTable where EmpNumber >= 51

You could make the parameter list static and just add the 51-100

mlmcc
0
 
James0628Commented:
In addition to mlmcc's suggestions, you could let them choose any number, but then basically have the report ignore any that were outside of the desired range.  Something like:

{emp num} = {?emp param} and
{emp num} > 50


 That way if they select any numbers below 51, the report still won't include them.

 However, if this is some kind of security issue, note that if they're running the reports from CR, they could always go into the record selection formula and remove the > 50 condition.

 James
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now