User grouping option

  • Thread starter Thread starter Lindee
  • Start date Start date
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
 
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.
 
Back
Top