Group Sort

[2006 IR Open Dicussion]

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.