Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding second value to existing parameter

Status
Not open for further replies.

Ofina

Technical User
Feb 25, 2004
156
US
Right now I have two parameters already in existence in an older report. One is a vessel name and the other is a PO number. Right now they are separate and thus list in the drop down all PO numbers regardless of what vessel has been selected in the previous parameter.

I would to change the first one to include the second so that after users select a vessel, the PO drop down will only show POs on that vessel.

I have done this with other reports.

I can't add anything below in the values box. I can't insert a new one, it's greyed out. Do I have to go so far as to remove the use of the parameter before it will "free" it up for me to change?
 
If this is a dynamic parameter, you can't edit it as far as I know, so you would start over, and this time choose dynamic and and add vessel as your first value and click on parameter on the right, and then add the PO field as the second value and click on parameter on the right. Then add both parameters to your selection formula. This will create a dynamic cascading parameter, where the second one only contains values related to the first.

-LB
 
Darn. I was hoping I wouldn't need to do that. I think it's worth it for the user, though.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top