Summarizing a sequence of Distinct Counts

[SonOfZeus]

I'm having a problem trying to get a total for the distinct counts in groups at lower levels, any ideas.

The report tracks the distinct count of days a vehicle is used during a month. I want the report to total this count for a division. I tried using the formula that runs:

accums = accums + distinct count (Running Total)

But it counted the last vehicle twice in the division total which is bad enough and can be programmed around. The problem is that a total of all divisions doesn't tell the total of those duplicated so I can remove difference

 

[kenhamady]

You want a distinct count of Vehicle Days?

One way is to create an invisible formula that is:

VehicleID + ToText ({Date})

And do a distinct Grand Total (or subtotal) on that. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[HowardHammerman]

I hope Ken's response helped you.

If not, provide more info.

Your table has one record per vechicle per day ?
or (possibly) multiple records per vech. per day?

What are your groups?

Are you showing the detail?

Have you looked into a running total with a condition on the evaluation section?

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269