Is there a way to create a select option for users to be able to sort a
report the way they want when they run the report? Some users may want it one
way and then others might want it sorted another. How can I give them this
option, if at all?

Hi Ken,
Actually I do have one question...Where do I point the combo box to choose
the fields for my sort function? Do I create another table with these field
names or maybe a value list? I'm a little confused there.

Thanks
SS

"Ken Sheridan" wrote:

> You can set the report's OrderBy and OrderByOn properties in its Open event
> procedure. Say you are opening the report from a form with a combo box which
> lists the fields from which a choice of sort order can be made then you'd use
> something like this:
>
> Me.OrderBy = Forms!YourForm!cboSortOptions
> Me.OrderByOn = True
>
> You can alternatively set one or more group levels if these are already set
> up in the report, e.g.
>
> Me.GroupLevel(0).ControlSource = Forms!YourForm!cboSortOptions
>
> You can make the combo box on the form more user friendly by putting the
> field names in a hidden first column and in a visible second column more
> descriptive text expressions.
>
> Ken Sheridan
> Stafford, England
>
> "Secret Squirrel" wrote:
>
> > Is there a way to create a select option for users to be able to sort a
> > report the way they want when they run the report? Some users may want it one
> > way and then others might want it sorted another. How can I give them this
> > option, if at all?
>

That sounds like it will do it! Thanks Ken!

"Ken Sheridan" wrote:

> You can set the report's OrderBy and OrderByOn properties in its Open event
> procedure. Say you are opening the report from a form with a combo box which
> lists the fields from which a choice of sort order can be made then you'd use
> something like this:
>
> Me.OrderBy = Forms!YourForm!cboSortOptions
> Me.OrderByOn = True
>
> You can alternatively set one or more group levels if these are already set
> up in the report, e.g.
>
> Me.GroupLevel(0).ControlSource = Forms!YourForm!cboSortOptions
>
> You can make the combo box on the form more user friendly by putting the
> field names in a hidden first column and in a visible second column more
> descriptive text expressions.
>
> Ken Sheridan
> Stafford, England
>
> "Secret Squirrel" wrote:
>
> > Is there a way to create a select option for users to be able to sort a
> > report the way they want when they run the report? Some users may want it one
> > way and then others might want it sorted another. How can I give them this
> > option, if at all?
>

You can set the report's OrderBy and OrderByOn properties in its Open event
procedure. Say you are opening the report from a form with a combo box which
lists the fields from which a choice of sort order can be made then you'd use
something like this:

Me.OrderBy = Forms!YourForm!cboSortOptions
Me.OrderByOn = True

You can alternatively set one or more group levels if these are already set
up in the report, e.g.

Me.GroupLevel(0).ControlSource = Forms!YourForm!cboSortOptions

You can make the combo box on the form more user friendly by putting the
field names in a hidden first column and in a visible second column more
descriptive text expressions.

Ken Sheridan
Stafford, England

"Secret Squirrel" wrote:

> Is there a way to create a select option for users to be able to sort a
> report the way they want when they run the report? Some users may want it one
> way and then others might want it sorted another. How can I give them this
> option, if at all?

"Secret Squirrel" <(E-Mail Removed)> wrote in
message newsC7F8D0D-EE46-489E-992E-(E-Mail Removed)...
> Is there a way to create a select option for users to be able to sort a
> report the way they want when they run the report? Some users may want it
one
> way and then others might want it sorted another. How can I give them this
> option, if at all?