Report grouping selection by form

[Guest]

How can you create a report where you let the user select the Field/s on
which the report will be grouped on via a Form?

I tried creating a number of Iif statements on the sorting and grouping
properties on the report which dlookups into a form, but the field for
putting statements in the sorting and grouping properties does not have
enough field space for the length of my statement due to the number of field
options that I have.

 

[Duane Hookom]

Try the tip on Allen Browne's web page http://allenbrowne.com/tips.html.

 

[Guest]

I just recently figured this one out. I have a report that may have from 1
to 6 subtotals (grouping). I put a check box on my form for each subtotal
available. Then, it the Format event for each group header :
Private Sub grpBillNetworkHeader_Format(Cancel As Integer, FormatCount As
Integer)
Me.grpBillNetworkHeader.Visible = Forms!frmbporeports!chkBillNetwork
Me.grpBillNetworkFooter.Visible = Forms!frmbporeports!chkBillNetwork
End Sub