User grouping option

L

Lindee

I want my user to select how his report is grouped and
sorted. I made it group by [txtDepartmentHead] then it
lists details including [dtmTargetDate],[txtCPM], and
[ysnZoneRestricted].

We need a variety of group hierarchies and sort orders.
Can the user select this order, or am I better off just
designing six or eight different reports?

Thanks for the help!! Lindee
 
A

Allen Browne

In the Open event of the report, you can set the ControlSource of each
GroupLevel to reorganise the contents as desired.

Example:
http://allenbrowne.com/ser-33.html

You may also need to set the Left property or ControlSource of the text
boxes as well so they finish up in the desired locations.
 
Top