Dynamic Group Report

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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.
 
iccsi said:
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?
Click to expand...


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
 
Back
Top