Stepped format

[Nick Mirro]

We generate a report offering 4 different sort options by option group. The
sort options are listed identically in 2 option groups - 4 each - allowing 2
levels of sort.

I would like the result to display in a stepped format, the way the wizard
creates a report.


Category 1 (sorted by option group choice 1)

Record 1 (sorted by option group choice 2)
Record 2
Record 3

Category 2

Record 4
Record 5


In order to do this, it is necessary to create 16 differerent reports? If
not, can you suggest a method to accomplish this? Thanks.

Nick

 

[Duane Hookom]

If I understand correctly, there is code at
http://allenbrowne.com/ser-33.html allowing the sorting of a single report
to be changed at run-time.

 

[Nick Mirro]

Thanks for your help.

Nick

If I understand correctly, there is code at
http://allenbrowne.com/ser-33.html allowing the sorting of a single report
to be changed at run-time.