Sum of Counts in the drill down report


  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.
For License type, i have an aggregate, which does Count(License_ID, License_Type).
 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?
Please help.
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.

Does this work?


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

What grand total?

The sum of the Group2 counts should be the group1 count

JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

pvsbandiAuthor Commented:
I want to derive those Totals.

Example :

Group 1:

      HL Inventory          3
      IV Inventory           4
    Total Licenses          7

Drilling on Hl Inventory, i get something like this.

    Kim Canvas             1
    Frame Canvas         2
  Total Checklist          3
What do you need to change?

Ido MilletProfessor 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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pvsbandiAuthor Commented:
Thank you! I did that, suppressed the variable in the detail and displayed it in the footer and it worked out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.