sigmundlikestodrive
asked on
Multiple value parameters in Crystal Enterprise
I am using Enterprise 8.5 and have a report that accepts a parameter for customer ID. I've found examples for sending parameters via the URL for a single value and range values using PROMPTEX-<promptname>@<sub report>=<v alue>.
Single value: <value> = "4"
Range value: <value> = ("2"-"9")
The problem I'm facing is how do you specify multiple values that are not in a range. I want company ID 1, 4, 8 and 23, not the whole range from 1 to 23. If you do this:
<value> = "1","4","8","23"
It sounds like the report assumes you are getting values for 4 parameters, not 4 values for one parameter.
Thanks for your help.
Single value: <value> = "4"
Range value: <value> = ("2"-"9")
The problem I'm facing is how do you specify multiple values that are not in a range. I want company ID 1, 4, 8 and 23, not the whole range from 1 to 23. If you do this:
<value> = "1","4","8","23"
It sounds like the report assumes you are getting values for 4 parameters, not 4 values for one parameter.
Thanks for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help.
ASKER
I also found the syntex
&promptex0="1","2"&prompte
works well. This shortens the URL and makes is less recognizable to the user (which means it's less likely that they'll mess with it and then call me for support).
Thanks.