sql for crystal report - running total
Posted on 2015-02-19
I have an invoice list report that I run in ms access that I need to run in Crystal. I us ms scheduler to run this report Tue-Sat.
I was hoping for some help with the SQL in Crystal.
There are 3 parts to the report - I figure the last 2 sections can be done with sub-reports:
1) list all invoice data for previous day. (report is scheduled to run on Tues - so it lists all invoices done on Mon.)
2) Sub-report - Totals for days of the week other than yesterday.
3) Sub-report - running total for all days on the report.
Here's the output for a report run on Thru. 2/19/15
Date Company Inv# Amt
2/18/15 ABC 125 200
2/18/15 DEF 126 200
2/18/15 ABC 127 200
2/18/15 TOTALS 600
2/17/15 TOTALS 425
2/16/15 TOTALS 500
WK TOTAL 1,525
Not to sure about how to set up the SQL - I was using Date() & Weekday().
Any suggestions on where to start?
Thanks for your help.