Sorting Reports

[harris@compu-type.net]

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)

[salad]

Re: Sorting Reports

harris@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!ReportCal lingForm!txtSor tBy
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.