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,
soarhigherAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.