Get group data to populate at end of report 2

[crachic]

I am using Crystal 8.5.

I currently have two groups setup.
Group 1 - Bill Date
Group 2 - Insurance Code
I have totals for each group 2 and each group 1.

Example:
7/21/08 (Group Header 1)
AET 24 (Group Footer 2)
CIG 12 (Group Footer 2)
Total 36 (Group Footer 1)

7/22/08 (Group Header 1)
AET 6 (Group Footer 2)
CIG 5 (Group Footer 2)
Total 11 (Group Footer 1)

I am looking to get the grand total at the end of the report by each insurance code taking the bill date out of the equation. For example at the end of the report I am looking for something like this.

Grand Total
AET 30
CIG 17
Total 47

I am having trouble getting every insurance code used in the report to show at the end of the report. Currently I have the Group Name 2 field in the report footer and all it is poulating is the last insurance code used.

Any ideas?

-crachic

 

[lbass]

Insert a crosstab in the report footer that uses Insurance code as the row. Not sure what your summary is or on what field.

-LB

 

[dgillz]

Put a cross tab in the report footer. Use insurance code as the row, and as the summarized field, make it a count summary.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?