If you go into the custom reports section (and have several) the appear to be displayed in the order they were entered. This means an unalphabetical jumbled order when you have several. At the top of each column of the custom reports menu (where you choose which custom report to run) you can click on the column to sort alphabetically.
However, if I log out and log back in again, that 'sort' is not saved, and so it appears jumbled again. Is there a way to save which column is sorted (perhaps on a per user basis), or to make the default sort be alphabetical by Report Name? That way it won't look so jumbled.
Custom Reports - Sorting MLS 3.1.4
-
- New Member
- Posts: 1
- Joined: Tue May 26, 2009 4:11 pm
- Location: Orem, UT
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
That's the way MLS works throughout -- the sort order is not saved. It would be a nice enhancement, but there's no way you can save that setting the way MLS works now.marker wrote:If you go into the custom reports section (and have several) the appear to be displayed in the order they were entered. This means an unalphabetical jumbled order when you have several. At the top of each column of the custom reports menu (where you choose which custom report to run) you can click on the column to sort alphabetically.
However, if I log out and log back in again, that 'sort' is not saved, and so it appears jumbled again. Is there a way to save which column is sorted (perhaps on a per user basis), or to make the default sort be alphabetical by Report Name? That way it won't look so jumbled.
- mkmurray
- Senior Member
- Posts: 3266
- Joined: Tue Jan 23, 2007 9:56 pm
- Location: Utah
- Contact:
-
- Senior Member
- Posts: 1345
- Joined: Wed Jun 11, 2008 9:52 pm
- Location: Austin TX
- Contact:
mkmurray wrote:I suppose we could suggest a different default sort. It may not be what everyone wants, but I think the current "created date" sort is not helpful to most units. I would prefer an alphabetical by default (especially since that is the first column in the table layout).
I would guess that the default sort is either by "Indiv ID" for members or "HofH ID" for households, which may be the primary keys for the internal tables. That sort order would effectively be similar to "created date" since both those ID fields are just incremented integers.
Unfortunately, these two ID fields are not exposed in the custom reports, but only in the export files.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
The topic of this thread is the sort order for the list of custom reports itself, not the results of any particular custom report. So Indiv ID and HofH ID aren't really possibilities -- it is indeed just sorted on the creation date at this point.boomerbubba wrote:I would guess that the default sort is either by "Indiv ID" for members or "HofH ID" for households, which may be the primary keys for the internal tables. That sort order would effectively be similar to "created date" since both those ID fields are just incremented integers.
Unfortunately, these two ID fields are not exposed in the custom reports, but only in the export files.
-
- Senior Member
- Posts: 1345
- Joined: Wed Jun 11, 2008 9:52 pm
- Location: Austin TX
- Contact: