I have a report that is grouping by two fields, field A & B. When the report is printing group A I would like the page header to be "Group A Header" when the report is printing the groups for field B I would like the page header to be "Group B Header". I can't seem to find a way to change the header based on which group is being printed. If I do "If GroupNumber = 1 Then "Group A Header"" it prints "Group A Header for the first group and the first record of the second field group.
Basically what I am trying to do is create a report that has a chart that is un-grouped followed by charts that are grouped. I've accomplished this by creating a formula that is always true for the un-grouped chart and adding it as a group. below that I have a field group for the charts I want filtered by group. When the un-grouped charts are printed I want the page header to reflect that, when the grouped charts are printed I want the page header to contain the group name.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.