Suppress subform conditionally?

[Paul Wagner]

I have a subform on a report. However, it is appearing in a Group footer. How can I control the printing of it (and/or its contents) so that it prints ONLY under 1 group?

TIA

 

[Paul Wagner]

Thanks Robert. On the surface I would agree with you. However, there is another occurrence of records in a group just after the reporting of this subform:
Group 1
Group Break A
row a: amt1 amt2 amt3
row b: amt1 amt2 amt3
Group Break B
row c: amt1 amt2 amt3
row d: amt1 amt2 amt3

Sum of Group 1 (my perceived notion of a single subform here)
Group A total total total
Group B total total total

Group 2
Group Break C
row e: amt1 amt2 amt3
row f: amt1 amt2 amt3

 

[Paul Wagner]

Pat: Sorry, I called you Robert (note to self: read...the...message...first)

 

[Paul Wagner]

OK, I suppose I could have another "recap" in last group, following the format of the first. However, I'm not sure how to do that without a subreport. I've created an artificial sort/group field to collect GroupA and B into Group 1, but I really don't know how to summarize those as displayed above.

The Group C group is a whole different reporting group for the user and they want to see it below the first.

I'll try the Onformat event. What kind of value test can I make?

Thanks!!!

 

[Paul Wagner]

Very cool and clean Pat. Thank you ever so much. And thank you for your generosity of your time. That too is appreciated!!

Paul

 

[Paul Wagner]

Yipes. I guess I got too excited too fast.

I thought Groupname was a natural construct and it became obvious you gave me a generic example.

What is Groupname? Does it have anything to do with the code?

Private Sub GroupFooter5_Format(Cancel As Integer, FormatCount As Integer)

 

[Paul Wagner]

Resolved. Thank you Pat. Yes, I was able to use the group name.

Paul