Dynamic Group Report

On Sep 1, 4:24*pm, Marshall Barton wrote:
iccsi wrote:
I have a report which has 3 levels which are detail, group 1 and group
2.

I would like to have my report has dynamic grouping,

For example, there is one radio button on the form which has 3 options
like details, group 1 and group 2.

If user selects details then there is no group to get whole report in
one group. If user selects group 1 then the report shows group 1 and
details.

Are there any example to have dynamic grouping?

You can only add or delete grouping entries at design time.
However, you can manipulate ***existing*** groups at *run
time by setting the GroupLevel (see VBA Help) properties in
the report's Open event procedure.

For example, you can effectively "disable" a group level by
setting the group level entry's control source to a constant
expression:

* * * * Me.GroupLevel(0).ControlSource = "=1"
* * * * Me.GroupHeader1.Visible = False
* * * * Me.GroupFooter1.Visible = False

--
Marsh
MVP [MS Access]

Thanks millions,