Dynamic Group Report

[iccsi]

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?


Your information is great appreciated,

 

[KARL DEWEY]

One way is to use the option group in an IIF statement of calculated field in
a query to pull data or null that is used in the report grouping.

 

[Marshall Barton]

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