Skip to Content
0
Former Member
Aug 20, 2010 at 09:13 PM

Group Header Showing/Not Showing

10 Views

This is the structure of my report:

Report Header

Page Header

GH1 (District)

GH2a (Territory)

GH2b

GH3 (Account)

Details (Suppressed)

GF3

GF2

GF1

Report Footer

Page Footer

In GH2a, the Territory name is listed along with some other labels. In the Group Expert, I checked "Repeat Group Header On Each Page".

At the top of GH3 is a gray box and a Formula Field with the Account Number in it. Just below that is a Cross-Tab that is created for each Account. There is no Page Break after each Account. For some of the accounts, the Cross-Tab will start on one page and finish on the next, which is fine. When the Cross-Tab does that, the box and account name don't show on the 2nd page, which is expected.

In GH2b, I put another box and a Formula Field with the account number, just like in GH3. I would like for this to be suppressed on a new page when there is a new group. I tried using "AccountID <> Previous(AccountID) but that didn't work.

I'm thinking I need to base the suppression off of the change of Account Group but I don't know how to do that.

Can anybody suggest a way for me to accomplish this?

If I need to clarify anything or provide any more information, please let me know.

Thanks.