Group Headers Based on Page Number
I have two group headers in report designer and wants Group1 only to bring on Page1 and Group2 only to print on Page2. The problem I am facing is that even though there are multiple pages in the report, the system sees both group headers in page1 so I cant use visible expressions with PageCount or PageIndex. Any suggestions?
Thanks for your response. I tried this and got no luck. In the pageHeaderSection1 when I add [PageIndex], [PageCount] or [PageOf] I get the proper data, however when I create variables using the fields, I get completely different data. For Example: $PageIndex =[PageIndex] I get '2' on Page 1, but when I just [PageIndex] I get '1' on page 1. Any ideas as to why that's happening?