MLS Custom Report Sorting Question

[upNin-p40]

We have 300 apartment units in our traditional style ward. We would like to run a report sorted by apartment building, then unit number in that building, and then organized by family position (HofH, spouse, then each child from oldest to youngest).

As I have tried to make a custom report work in this format using stake GEO Code (for the building number) and ward GEO Code (for the unit number), by placing the stake GEO code as the first column on the custom report and the ward GEO code as the second column on the report, I find there seems to be only 1 level of sorting within MLS. In this case, we get everyone in a building grouped, but randomly listed. We need the next 2 levels of sorting, i.e. apartment number, and family members.

I have seen some references in these forums to exporting data to another program. With as often as people move in & out of these apartments, that will be a bit of a pain. What suggestions do you have for this need?

Thanks.