ORA-00907: missing right parenthesis

[dtempleton]

Using CR 8.5 and Oracle 8i

I'm creating a report that uses one view and one grouping. Everything works fine at this point. As soon as I hide or suppress the detail lines, I get the error:

ODBC error: [Oracle][ODBC][Ora]ORA-00907: missing right parenthesis

I can hide/suppress the details when there is no group on the report. This error has happened with each of the views I've tried today, and it does not matter what the group is. Any clue what's going on?

Thanks,
Dave

 

[synapsevampire]

If you're going to use ODBC, use the Crystal supplied Oracle ODBC driver, not Oracles.

Better still you should use the Native Connectivity (under More Databases os some such in CR 8.5), it's much faster.

You might also make sure that your service packs are up to date:

http://support.businessobjects.com/fix/hot/si75/default.asp

-k

 

[dtempleton]

I've installed the latest service pack and hot fixes, and it still fails using either the CR Oracle8 driver or the Oracle ODBC Driver.

 

[synapsevampire]

Then you'll have to share meaningful technical information.

Post the Database->Show SQL Query and the Report->Edit Selection formula->Record and Group

Post what is in the details, such as formulas, RTs and SQL Expressions.

Something is getting misinterpreted by the driver it seems, but it's hard to say without knowing the specifics.

-k

 

[Turkbear]

Hi,
If you are using a formula to control the supression,
you need to post that as well..

Have you tried a Native Oracle connection?