rubedogg04 Posted June 27, 2008 Share Posted June 27, 2008 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? Link to comment Share on other sites More sharing options...
svenn Posted June 27, 2008 Share Posted June 27, 2008 Make sure that you are you using $P!{your value} for your value. Link to comment Share on other sites More sharing options...
rubedogg04 Posted June 27, 2008 Author Share Posted June 27, 2008 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. Link to comment Share on other sites More sharing options...
rubedogg04 Posted June 27, 2008 Author Share Posted June 27, 2008 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now