grouping on multiple fields

[caaso]

I have a recordset that includes two dates : order_date and delivery_date. I need a report with the following layout:

Date Orders Deliveries

Under Date I need a sequence of dates (which don't exist in the Database). Under orders and Deliveries I need the count of dates in the DB that match the current date in the sequence. Kind of like grouping the recordset by both dates and then having a running total to count them. Is this possible at all ? Anyone ever done something like this.

Thanks in advance
Tom

 

[kenhamady]

You can either create a table of the dates, and then link this table to the date field in the other table using an outer join.

Or you can type these dates in the report footer as labels, and create a total to print next to each one.

You would need a formula for each total with a condition like:

if datefield = Date1 then amount else 0

Add a grand total of each column to print next to the corresponding label. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal