Problem with sum ora-00907 missing right parenthesis

landaz · Post by **landaz** » Thu Oct 23, 2008 4:44 am

Hi! I have a problem with a query that contains a sum clause. When executing it in stimulreport.net 2006.4, I get a missing right parenthesis error. I´ve tried the query directly to oracle, throught sql plus, and I have no problems. My query is:

...
SUM(CASE WHEN date1 > date2 THEN nvl(value, 0) ELSE 0 END)
...

If I use:

...
SUM(value)
...

There is no problem.

Thanks!

Post by **Edward** » Thu Oct 23, 2008 6:48 am

Hello, Landaz.

Please click that DataSource in the Dictionary and switch to the 'Properties' window. Set 'AllowExpressions' in false.

Thank you.

landaz · Post by **landaz** » Fri Oct 24, 2008 5:31 am

I have solved the problem by rewriting the query using a decode.

Thanks a lot!

Post by **Edward** » Fri Oct 24, 2008 6:59 am

Hello, Landaz.

Let us know if you need any help.

Thank you.