• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

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>@<subreport>=<value>.  

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.
  • 2
1 Solution
Looks like what you're doing should work - The proper syntax for passing multiple values to a PROMPTEX-ParameterName parameter through a URL command is:


From: http://support.businessobjects.com/library/kbase/articles/c2011349.asp

Is the parameter field in your report set up to allow multiple values?

sigmundlikestodriveAuthor Commented:
This does work.  I'm not sure if there was something wrong with my parameter field, or I did something wrong with I exported to Enterprise, but it works now.

I also found the syntex


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).

Glad to help.

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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now