Creating reports and dashboards | Stimulsoft community forum

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!

Hello, Landaz.

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

Thank you.

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

Thanks a lot!

Hello, Landaz.

Let us know if you need any help.

Thank you.