Skip to Content
avatar image
Former Member

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


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.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • 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:


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


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


    Add comment
    10|10000 characters needed characters exceeded