Date Record Count For Crystal 8.5

Posted on 2009-04-24
Last Modified: 2012-06-22
I have about 80,000 records ranging from 2005 thru present.
I have the report sorted by date and I want to sum the total amount of records for each year.

Date record is being displayed as: 01/01/2005 and so on.
Question by:CarloVasquez
    1 Comment
    LVL 100

    Accepted Solution

    Assuming they are dates
    Add a group on the date field
    Specify the period to be YEAR
    Put a field into the detail sectiion
    Right click the field
    Click INSERT --> SUMMARY
    Make the summary of type COUNT
    Put the summary in the year group footer

    Another way
    Add formulas
    If Year({DateField}) = 2005 then

    Add one for each year

    To get the total for each year
    Add a formula


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now