Data extraction and layout

[ecugrad]

I've been tasked to produce a monthly report that totals the number of Account Numbers that have been terminated through our imaging system each day. We want the report to show the totals for each day of the month. How do I write a formula using my "TerminateDate"(DateTime) and AccountNumber fields that will sort and print on one report by each day. exp:


Days: 1 2 3 4
Totals: 50 100 75 80

I have to do this for many departments and I really want to keep from pulling the numbers each day and placing them on a spreadsheet.
I'm using Crystal 8

Thanks for any help!!!

 

[kenhamady]

Do the headings 1-2-3-4 represent days of the month?

If so I think a Cross-tab is what you want. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.