ReportServer Forum

mongonv

Member

Registered: 2015-07-31

List of values for parameter on Crystal Report throws error

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 ?

Thorsten J. Krause

Guest

Re: List of values for parameter on Crystal Report throws error

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

wonky

Member

Registered: 2016-03-01

Re: List of values for parameter on Crystal Report throws error

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?

AChater

Member

Registered: 2021-03-23

Re: List of values for parameter on Crystal Report throws error

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