Need to print line on report when no data exists in table

[merceng]

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.

 

[Madawc]

Two ways I can think of:
a) Get a new table set up with one entry per date
b) Do a 'mock crosstab', a set of running totals that will each look for a particular day, using a formula test.

Madawc Williams (East Anglia, UK)