Hello everyone!
I am using Crystal 10 with an ODBC connection to an Interbase database.
I need to produce a machine scheduling report that will take a start date as a parameter and print records for the next 30 days.
My problem is that I need to produce a line on the report even when no scheduling data exists for a particular date eg
Date__________Qty__________Description
20/06/05_______20___________End Cap
21/06/05
22/06/05
23/06/05_______40___________Inlet Stub
.
.
.
20/07/05_______10___________Treaded Pin
I don’t have a table containing the dates, so I will have to generate them myself in the report.
Any suggestions on how to do this would be greatly appreciated.
Many thanks.