Report grouping

[LindaG]

I have data that the user wants grouped and subtotalled about 8 different ways. I figure by using the group visible property in the report, I can can accomplish this in three different reports. Other than the grouping, the reports are identical. I would like to do it in one report, allowing the user to select grouping options in a form and dynamically changing the group options. I would have to populate the group headers with appropriate labels and group footers with appropriate subtotalling textboxes. Any and all suggestions and ideas are welcome. Please keep in mind I am an inexperienced coder.

 

[Abby N]

My best advice is to go ahead and make the 8 different reports. But, if you're dead set on doing it with code, take a look at the CreateGroupLevel Function in the help file.

~Abby

 

[bob makepeace]

Hi,

I have a similar problem and have used
the creategrouplevel function.

It works excellently except I can't see
how to delete the groups created so I can
build a new grouping afresh.

any tips?

thanks

bob

 

[Travis]

You can accomplish not showing a GroupLevel by setting the Groups visible property to False. You can also change what a grouplevel groups on by code. See GroupLevel or Sections in the Help File.

 

[bob makepeace]

thanks

bob