Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

merceng

Programmer
Jul 28, 2005
3
GB

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.
 
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.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top