I am finalizing a Financial Report in Crystal 8.5, where I am having difficulty keeping the detail records with the correct group when the report is generated. In the example below, the report contains four hierarchal groups in the following order: 1). FUND, 2). ORG, 3). REVENUE, 4). PARENT ACCOUNT; and then sorted by CHILD ACCOUNT ( DETAIL) . I have a page break after each revenue group, and a page break after each ORG Group. This keeps the detail with the correct ORG, however, I get an blank header page between each change of ORG which I am trying to avoid. If I do not include the page break after each ORG, then the ORG spans the page, and becomes associated with the next set of detail incorrectly. Any Suggestions?
FUND 1000 header group 1
ORG 500 header group 2
6953 PARKING FUND TRANSFER 228,019 detail
6961 WATER O & M TRANSFER 677,849 detail
PARENT 6900 905,868 grp4 subtotal
5253 SALES TAX2 2,257 detail
5255 R & B 4,785 detail
PARENT 5200 7,042 grp4 subtotal
** TOTAL REVENUES 912,910 group 3 subtotal
Ken
FUND 1000 header group 1
ORG 500 header group 2
6953 PARKING FUND TRANSFER 228,019 detail
6961 WATER O & M TRANSFER 677,849 detail
PARENT 6900 905,868 grp4 subtotal
5253 SALES TAX2 2,257 detail
5255 R & B 4,785 detail
PARENT 5200 7,042 grp4 subtotal
** TOTAL REVENUES 912,910 group 3 subtotal
Ken