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.
Ron
|