My brain is failing me miserably!
I have a report that has a:
Report Header
report Footer
Page Header
Page Footer
PVD Header
PVD Footer
Measure Header
Measure Footer
Member Header
For my report the data that is in the Header should be produced like that of a cover page. The remaining data is grouped and sorted by PVD, then by Measure (and there can be 3 measures), then by Member. Therefore, the report should be a Cover Page for the PVD, the Measure for that PVD with it’s respective members, etc.
For instance:
Cover Page[INDENT]PVD-John Doe[/INDENT]
[INDENT=2]Measure -1[/INDENT]
[INDENT=2]Measure -2[/INDENT]
[INDENT=2]Measure -3[/INDENT]
[INDENT=3]Member[/INDENT]
[INDENT] [/INDENT]
Cover Page
[INDENT]PVD-Jane Doe[/INDENT]
[INDENT=2]Measure -1[/INDENT]
[INDENT=2]Measure -2[/INDENT]
[INDENT=2]Measure -3[/INDENT]
[INDENT=3]Member[/INDENT]
I have all of it working except the Cover Page, I can’t seem to get a new Cover Page when the data changes to a new PVD. Can someone offer a suggestion please. BTW, I’ve placed a force new page “Before Section” in the Report Header property.
Thanks in advance.