Parameters in ORDER BY

[sdemills]

I'm a relative beginner with iReport. I've built a report with Parameters and they all work ok apart from the one in the ORDER BY clause which reads ORDER BY $P{pSequence} DESC, and more keys.

If I include the parameter in the report body then I can see that it is being set correctly.

If I edit its value into the SQL statement instead of using the Parameter substitution above, then I get the right results.

However if I use the substitution above then the sequence does not come out as desired. I can't tell yet whether that part of the ORDER BY is being ignored or whether the entire ORDER BY clause is being ignored. No error is reported and the report is generated ok but not in the desired sequence.

So given that the substitution is working in the report itself - I see the value printed out - and given that parameters used in the WHERE clause are working fine, why doesn't the parameter in the ORDER BY clause work?

Any ideas? Or worked examples where it does work?

Kind Regards
Steve

 

[Gaby38]

I don't know what is the exact content of your "$P{pSequence} but if there are strings, I fear that the expansion which takes care of type adds some quots.

Try using "$P!{pSequence} (notice the "!")which will expand the parameter as is.

Hope this helps

[sdemills]

That solved it. Thank you very much for the tip. I was just on the point of getting my calling Java program to read back the jrxml file and edit the query on the fly. That was a really useful tip and I've written it down for future reference.

Kind Regards

Steve

[pandemic30]

Same issue as OP, this solved it, thanks!

[tekhne]

 A mi me funciono como: $P!{pSequence}