# Sum of Counts in the drill down report

hi,

I'm on Crystal Reports 2008.
I have a report with two Drill down levels.
First one is on the License Type and the second one is on the Checklist Items.
I want to add a grand total to this list of License Types and aggregates.
Similarly, i need a grand total for the Checklist Item counts, in the next level.

Crystal is not letting me sum the count objects. How can i achieve this?
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Does this work?

mlmcc
0
Author Commented:
No, it doesn't.
For Group 1, i have the formula COUNT(LICENSE_ID,LICENSE TPYE) for the summaries.
For Group 2, it is COUNT(LICENSE_ID, CHECKLIST ITEM).
I need to sum them up as grand totals at each level.
0
Commented:
What do you mean sum them up?

What grand total?

The sum of the Group2 counts should be the group1 count

mlmcc
0
Author Commented:
I want to derive those Totals.

Example :

Group 1:

HL Inventory          3
IV Inventory           4

------------------------------------------

Drilling on Hl Inventory, i get something like this.

Kim Canvas             1
Frame Canvas         2
------------------------------------------
Total Checklist          3
0
Commented:
What do you need to change?

mlmcc
0
Professor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Crystal doesn't allow you to total totals.  But you can total at a grand level directly.
For a grand sum, simply create a formula summing a detail level item without a second argument for the Sum expression:  Sum({your_Field})

To control what sections are visible in the drill-down, use DrillDownGroupLevel in a dynamic suppress expression for the section.
0

Experts Exchange Solution brought to you by