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!

Parameters

Status
Not open for further replies.

charltonc

IS-IT--Management
Mar 2, 2004
23
CA
I want to make a parameter to show all the value of one of the parameter

when I use True, all the parameters will show all of the values but I don't want that.

for example:

2 fields: F1 and F2

F1 contains 1,2,3,4,5...9
F2 contains a,b,c,d,e...z

I want the user to be able to choose F1's value and F2's value

but when they choose F1 = all, and F2 = e
I want them to see
1,e
2,e
3,e
.
.
.
9,e

Help
Thanks in advance!
 
You could do this with two parameters:

(
If {?Parameter1} <> "All"
Then {table.field} = {?Parameter1}
Else If {?Parameter1} = "All"
Then True
)

AND

(
If {?Parameter2} <> "All"
Then {table.field} = {?Parameter1}
Else If {?Parameter2} = "All"
Then True
)


~Kurt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top