?
Solved

Date Record Count For Crystal 8.5

Posted on 2009-04-24
1
Medium Priority
?
403 Views
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.
0
Comment
Question by:CarloVasquez
1 Comment
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24228198
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
1
else
0

Add one for each year

To get the total for each year
Add a formula
Sum({2005YearFormula})

mlmcc
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month14 days, 16 hours left to enroll

840 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