Report Grouping

[Pauldohert]

I have a report which is basically a list of records. (there is no subreport or anything else)

WHat I need is to group this report in various ways.

1) By customer name - so see all recoprds for this customer together
2) By product - so see all of a products records togther.


Rather than make 2 reports to do this - can I do it with one report - and eneable/disable the grouping as the report opens?

Thankyou

 

[Pauldohert]

I'm not sure if bumping is allowed - so I'll give it a try.

 

[Christianm]

I have the same problem as yours, so if you solved it can you please post the solution.
thanks

 

[Pauldohert]

Th solution I have use is to put all possible groupings onto the report - including footer/headers etc.

Then pass open args to tell the the rpeort which grouping actually need to be shown.

So in the case below - "Geo" isn't in the open args so the grouping for geo is not visible - additionally the source is set to 1 so it all groups the same anyhow.


If InStr(1, wCase, "Geo") = 0 Then
Me.GroupLevel(0).ControlSource = "=1"
Me.GroupHeader1.Visible = False
Me.GroupFooter0.Visible = False
End If

I had slight trouple with the numbers for Level, header, footer etc - seems level is the order they appear in the groupby box (includes sorts) and the other header and footer numbers (names) I have taken directly from the report design.

This seems to do what I want it too.