Skip to Content
avatar image
Former Member

For JDBC source, Command object not recognizing '(' character

Hello

I am trying to create a crystal report from a JDBC source query (which is actually pointing to Clearquest Oracle database). The query accepts a parameter to filter down data.

Issue I have is when I try to pass a parameter in the command object used for defining the Data Source (See attached screenshot), somehow the parsing ignores anything entered beyond the open bracket character - '('.

In the example screenshot attached, notice how everything I have entered beyond ( is ignored totally in the error message.

I somehow need to find a way to pass this parameter & for that I need the system to understand the ( character.

Any help is appreciated.

Cheers

Satish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 02:00 PM

    You're not handling the parameter correctly.  In order to use a parameter in a command, you MUST create the parameter in the Command Editor.  You would then use it like this:

    Get_Software_Defect_by_ID_wofilt({?Parameter1})

    If the data type of the parameter is a string, it would look like this:

    Get_Software_Defect_by_ID_wofilt('{?Parameter1}')

    See my blog for more information about working with commands in Crystal:  Best Practices When Using Commands with Crystal Reports

    -Dell

    Add comment
    10|10000 characters needed characters exceeded