• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • 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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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