report without detail records

[Slez via AccessMonster.com]

I have created a report called rptFinishFormula that is viewed at a couple
different times. It is first a sort of internal order request, and the only
data that exists is all in the header of the report. Then our Finishing Dept
develops the "formula" and enters records into a subform, which then shows up
in the detail section of rptFinishFormula. The report will not display any
of the header data (everything is blank) without at least one record in the
detail section. I was thinking a way around this would be to have default
data in the fields that fill the detail section, but is there a better
alternative? Is there a report setting that would allow a report to generate
without a record in the detail?

Any suggestions are apprciated!

 

[Marshall Barton]

I have created a report called rptFinishFormula that is viewed at a couple
different times. It is first a sort of internal order request, and the only
data that exists is all in the header of the report. Then our Finishing Dept
develops the "formula" and enters records into a subform, which then shows up
in the detail section of rptFinishFormula. The report will not display any
of the header data (everything is blank) without at least one record in the
detail section. I was thinking a way around this would be to have default
data in the fields that fill the detail section, but is there a better
alternative? Is there a report setting that would allow a report to generate
without a record in the detail?

It sound like your report is based on a query that uses an
Inner Join. If so, change it to an outer join. If you
don't understand what I talking about, open the query in
design view. Then click on the connecting line between the
two tables. then right click on the line and select Join
properties from the pop up menu. Finally, select the option
that returns all records from the orders table and any
matching records from the formulas table.