By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Sorting Reports

P: n/a
I have a list box on a Form labeled "txtSortBy". How do I pass this
field to a Report to order the way I have chosen on the Form?

Currently, I have created 3 of the same reports and hard coded the
sorting within each Report. (What a drag to maintenance when I want to
make a design change and must update ALL three of these reports,
instead of just one)

Nov 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ha****@compu-type.net wrote:
I have a list box on a Form labeled "txtSortBy". How do I pass this
field to a Report to order the way I have chosen on the Form?

Currently, I have created 3 of the same reports and hard coded the
sorting within each Report. (What a drag to maintenance when I want to
make a design change and must update ALL three of these reports,
instead of just one)
In the OnOpen event you could do something like
Me.OrderBy = Forms!ReportCallingForm!txtSortBy
Me.OrderByOn = True

For the most part, reports are sorted on what you have specified as the
group level sorting. Look at GroupLevel Property in help and related
topics.
Nov 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.