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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access2007: CustomReport - User entered Sort order 0
Trouble with my sorting and grouping 2
Coordinating the sort order in a report with the underlying query 2
Dynamic Group Report 2
Grouping and Sorting a Report On Open Event 3
Sort by second field within a group header 2
Sort Order 5
Sorting a Report Based on Criteria 2

Back
Top