This is the structure of my report:
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.