I'm trying to figure out how to limit the number of items in a parameter field. I have "report numbers" that I want in a drop down list, but I don't want all of them, only maybe the last 20. In the parameters area I have a parameter with the available values set to "get values from query" which produces all the items from my dataset I want. I'm not sure how to go about doing the limits. I had thought of two "parameters" but I got an error when I tried to specify the values as @reportnumber for the label and @reportnumber for the value. The error is something about "forward dependencies are not valid". David Jenkins

that error message means you have a parameter that depends on the value but its listed first. Change the order of the parameters in the parameter list to resolve this issue. I am having a hard time following as far as what you are really attempting to accomplish but to limit the available options for a parameter you simply link it to a query that returns the rows you want, or hard-code them in as non-queried values.

I'm trying to create a drop down list that has some tracking numbers. Tracking numbers will be added all the time so eventually my ddl will grow because of the addition of more tracking numbers. I want to limit the number of tracking items that shows so over time the list doesn't grow so big it runs off the screen. I could always make the parameter a text box and make them type the number in but this way seemed nicer. The data I'm looking up is from a Sharepoint list. David Jenkins

Hi David Jenkins, Use Some Default Values if you have any cascading. For example, use cascading between the parameters and Default the parameter values. For instance, Branch Numbers Dallas 1201 Dallas 1202 If you cascade Numbers parameter with Branch and Defaulting Branch value to Dallas then it won't show all the Branches details.This results less time to populate parameters. Thanks Tarak.

That is a good idea.David Jenkins

I figured it out. I created a new dataset with just the numbers in them. Then I filtered for "Top N" with a value of 30.David Jenkins