• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • 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.
0
sigmundlikestodrive
Asked:
sigmundlikestodrive
  • 2
1 Solution
 
frodomanCommented:
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:

    promptex-ParamName="1","2","3","4"

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

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

frodoman
0
 
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

&promptex0="1","2"&promptex1="2","3"

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.
0
 
frodomanCommented:
Glad to help.

0
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

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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