I have a subfile grid that shows the date using our corporate standard: ddMmmyy, e.g. 03Jan11, 23Apr11, etc. The subfile grid is initially loaded in date order, but clicking on the column heading sorts alphabetically, so Apr 3 comes before Jan 3. How can I display one field, but have another one control the sorting? If hidden fields can control the sort, how do I know which field in the column will be used?
--Bryan
Subfile sorting
-
Bryan641
- Profound User
- Posts: 72
- Joined: Fri Oct 01, 2010 5:07 pm
- First Name: Bryan
- Last Name: Leaman
- Company Name: InVue Security
- Phone: 704-752-6513 x221
- Address 1: 15015 Lancaster Hwy
- City: Charlotte
- State / Province: North Carolina
- Zip / Postal Code: 28277
- Contact:
-
Alex
- Profound Logic Staff Member
- Posts: 233
- Joined: Fri Jan 04, 2008 12:10 pm
- First Name: Alex
- Last Name: Roytman
- Company Name: Profound Logic Software
- Contact:
Re: Subfile sorting
Hidden fields can be used to control sorting. If you have more than one field in a column, the field that appears first in the Elements tab of the Designer will be used for sorting. You can change the order of the fields on the Elements tab by clicking the Move Up and Move Down arrows at the top.
-
Bryan641
- Profound User
- Posts: 72
- Joined: Fri Oct 01, 2010 5:07 pm
- First Name: Bryan
- Last Name: Leaman
- Company Name: InVue Security
- Phone: 704-752-6513 x221
- Address 1: 15015 Lancaster Hwy
- City: Charlotte
- State / Province: North Carolina
- Zip / Postal Code: 28277
- Contact:
Re: Subfile sorting
Thanks. That worked well.
--Bryan
--Bryan
Who is online
Users browsing this forum: No registered users and 2 guests