List of values for parameter on Crystal Report throws error

ReportServer (EN)
1

Having an issue with Crystal Reports running in ReportServer, where the report has “select list” type parameters.

Outline:

We have several Crystal Reports that I'm trying to set up in ReportServer.  All of them have one, or more parameters where the user needs to select a value from a listing.
The report is setup in Crystal Reports with the parameters defined as having a list of values to pick from;
The parameter is defined in ReportServer as a "Data Source Parameter"
The Datasource for it in ReportServer is a "CSV" type (Text Connector).
When we attempt to run the report in ReportServer, we get an error popup of "Regex test failed" after selecting the parameter values, and clicking Preview.

Example:

In Crystal Reports, the parameter is defined as:
Parameter Name = “Event selection”
Type = String
Prompt Text = “Choose the point in permit process to report on”
Allow Custom Value = True
Allow Multiple Values = False
Value Range Kind = Discrete
List of Values = [Received] [Finaled] [Denied] [Approved]
Initial Value =
Prompt with Description = False
Edit Mask =
Min Length =
Max Length =

In ReportServer, the parameter is defined as a “Data Source” type, connected to a CSV defined Datasource.
Datasource = “Event_Selection”
Selection Mode = “Single Selection”
Selection Style = Dropdown
DataType = “java.lang.string”

The Datasource for it is defined as:
Name = “Event_Selection”
Quotes = "
Separator = ;
Database cache = -1
Connector = “Text Connector”
Data =
Value;Name
Received;Received
Finaled;Finaled
Denied;Denied
Approved;Approved

Question:

  1. What could be causing the “Regex Test Failed” error ?
  2. Since the error happens immediately after selecting the parameter value, and clicking Preview, no error listing or output is produced, how to we triage to determine the true cause in a case like this ? is there a log file for ReportServer that is accessible ?
  3. If so, are logging levels selectable ?
2

Hi,

the problem is the value of the parameters “key” attribute, which may not contain spaces. Usually you are prevented from even creating a parameter with an invalid name, but you probably used the “extract parameters” function, which bypasses the test.

Changing the parameter name should resolve this.

Cheers,
Thorsten

3

We are seeing this error in the latest version of Enterprise. Our extracted parameter names don’t have spaces, but do all start with @ . Suggestions?

4

I had the same problem as you and YES! your name should not contain any space or @, %, !, ? … you got the idea