View Full Version: Sorting List Names In Report List

LawsonTalk > Reporting (NEW!!) > Sorting List Names In Report List



Title: Sorting List Names In Report List
Description: LBI sorting of List Names


mtom5 - October 25, 2007 02:29 PM (GMT)
see the attached file for a screenshot of report lists - my question: Can this list be sorted alphabetically??

cjmart - October 25, 2007 04:46 PM (GMT)
Not without modifying application code.

mnye - October 25, 2007 06:50 PM (GMT)
if you feel like experimenting, there is a table called ERS_LISTS in the RS Repository. I would bet the lists are displayed exactly as they are inserted in this table. you could dump this table, sort it the way you want it and delete the old and insert the new records.

THIS IS PURELY SPECULATIVE. Ive never done it, just making an educated guess.

cjmart - October 25, 2007 07:44 PM (GMT)
That should work. You could probably also add an ORDER BY to the sql in the java code and recompile it, but I'd stay away from doing that. Either way..."All", "History","Favorites", and "Unsubscribed Email" will always be listed first unless you modify ersReports.xsl.




Hosted for free by InvisionFree