I still can't get this to work unfortunately and would really appreciate any help.
Perhaps an explanation is required. I'm trying to pull together some security reports that identify permissions by user group for items on menus. I want to mimic the sequence to make it easy to cross reference. Some menus/items won't appear in the security report for all user groups e.g. no access for a group of items means the lower level items won't appear; I resolved this (I believe) by creating an autonumber based on the concatenation of all the levels.
This is an example of a menu for a module:
The items for 'Places' and 'Common Forms' are not grouped as such, whereas those items e.g. Journals/Reports etc do.
Attached is a qvw which contains the transformed security report for a single user group and hopefully demonstrates the sorting issue.