Sorting and grouping through code

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi everyone,

I've a question:

is it possible to add group headers and footers and sort, like in the
Sorting and Grouping dialog box, from code?

if so, how do I do that?

Thanks,

Martin.
 
It is possible to create new GroupLevel entries only if you open the report
in design view, so not at all in an MDE or runtime.

One workaround is to create as many levels as you will need (e.g. 5), and if
you need only 3, set the last 3 to the same field. You can assign the
ControlSource of the GroupLevel in the Open event of the report. Example at:
http://allenbrowne.com/ser-33.html
 
Thanks!

Regards,

Martin.

Allen Browne said:
It is possible to create new GroupLevel entries only if you open the report
in design view, so not at all in an MDE or runtime.

One workaround is to create as many levels as you will need (e.g. 5), and if
you need only 3, set the last 3 to the same field. You can assign the
ControlSource of the GroupLevel in the Open event of the report. Example at:
http://allenbrowne.com/ser-33.html
 
Back
Top