Group Sort

By: Martin G. Heinrich - martingheinrich
Group Sort
2002-11-26 22:23
Hello

It's possible to sort a group in the reports with other criteriy than the SQL statement?

Regards
Martin




By: Jindra Vavruska - ok1fou
RE: Group Sort
2002-11-27 08:30
Q: What would be the reason for having different ordering if the only thing you have the query for is to make the report of it?

Regards,

Jindra V.






By: Steven Blough - stevenblough
RE: Group Sort
2002-11-27 10:01
I assume you want to resort the data without having to make another call to the database. Currently I use this functionality to allow report users to resort some of our reports by clicking on a column heading. If you would like this class just let me know and I can send it to you or post it with the patches.

Good luck

Steven Blough





By: Martin G. Heinrich - martingheinrich
RE: Group Sort
2002-11-27 21:59
Hi Steven

oh yes, I'm very interresting of your class. Please send to me (mhe@marisma.com)

Thank you

Martin Heinrich




By: Ian Sleigh - isleigh
RE: Group Sort
2002-12-02 23:11
I have a similar problem - any chance of having a look at your class - mail to ian.sleigh@cnm.co.uk

Many thanks




By: Steven Blough - stevenblough
RE: Group Sort
2002-12-03 06:42
I added the classes to the patches area under the patch name of Sortable Datasource.

Good Luck
Steven Blough




By: Martin G. Heinrich - martingheinrich
RE: Group Sort
2002-12-03 09:06
Thank you very much,

and what must don that I can use the click on a column, or do you have a xml.sample?

Martin




By: Steven Blough - stevenblough
RE: Group Sort
2002-12-03 11:10
The sorting must be controlled in the code. So if you are using JSPs to display the pdf you would use a hyperlink to refresh the report with a sort parameter. The jsp would then regenerate the pdf bassed on the new data order. A warning though, in most cases the filling of the report is where most of the generation time is so you may not see much of a performance gain but you do reduce the load on the database.