I would like the top 100 newest records (could be filtered by date or PrimaryID, as primary ID is sequential) to be sorted by Name.
I can easily get the 100 newest records if I sort by PrimaryID or Date and return only 100 records, but then the records are sorted by PrimaryID, I'd like to sort them by name.
Basically create a dataset filtered by sorted data, then sort the display using a different field.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
LWSChad
Hi,
I would like the top 100 newest records (could be filtered by date or PrimaryID, as primary ID is sequential) to be sorted by Name.
I can easily get the 100 newest records if I sort by PrimaryID or Date and return only 100 records, but then the records are sorted by PrimaryID, I'd like to sort them by name.
Basically create a dataset filtered by sorted data, then sort the display using a different field.
Any Ideas?
Thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.