Has anyone encounterd this problem in iReport?

[rubedogg04]

I am on version 2.0.4. I tried to upgrade to 2.0.5 and all my reports stopped working. So i was forced to downgrade back to version 2.0.4. I haven't tried version 3.0.0 yet. Need to know if my reports created in 2.0.4 will work before i waste my time.

 

Anyway, that is not my real problem. Are any of you experiencing the errors in your report queries. I am using SQL, which works fine in sqlplus and sqldeveloper, but in iReport it keeps giving me a java.sql.SQLException: ORA-00937: not a single-group group function

 

error. I am using parameters in the group by and am wondering if that's what the problem is, CAUSE when i hardcode the values it works fine.

 

please help. . .Giulio? you know why this is happening?

[svenn]

Make sure that you are you using $P!{your value} for your value.

[rubedogg04]

no man. i am not doing that . the group by works when i hardcode the value in. It doesn't work when i use the parameter $P{p_tab}. I simply don't think that group bys work with parameters in iReport.

 

here's an example:

 

group by decode($P{p_tab},1,2,

2,2,

2,3)

 

when i run it hardcoded with let's say , 1, i get back the result of 1. When i pass 1 using the parameter, i get the "not a group by function error" I have tested the sql and it works. Just not in iReport.

[rubedogg04]

so i gave this a shot. I did this $P!{p_tab} instead of $P{p_tab} and it now works...go figure that all it was was a !. thanks!