How to get percentage in detail section?

[christiey]

I am using CR 8.5 and try to display count and associated percentage in detail section. The problem is the subtotal will generated after detail section. How can I get the total to calculate the percentage in detail section? The following is the sample report I plan to generate:

Type: Moving citation
Violation This Month Last Month
Count % Count %
---------- ------ ------ ------ ------
chargeA 120 60.0 100 66.7
chargeB 30 15.0 30 20.0
chargeC 50 25.0 20 13.3

Total 200 100.0 150 100.0

The main report is group by citation type (first column)and using shared variable to calculate total. The count information is from subreport. How can I calculate the percentage for each charge? Help!!!

 

[dgillz]

Just write a new formula and pick out the subtotal and grand total objects and put them in a formula like the opne below:

Sum({databasefield},{Charge})/Sum({databasefield})*100

They will automatically calculate after the totals, but will still work fine. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[christiey]

It works! Thanks so much!