create/print Access 2007 report

[HJC]

I have used earlier versions of Access and have been able to create and print
reports; I created the first report in 2007 using the wizard yesterday - I
have done this several times and each time the report is blank - the header
is there but no data - and I know there is data. I am guessing there is
something simple I am missing but I have been unable to find what that
missing step is. Any help would be appreciated!

 

[Allen Browne]

Suggestions:

1. Have you applied Service Pack 1 for Office 2007 yet? If not:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5

2. Open the report in design view, and clear its Filter property (in the
Properties sheet.) You may also want to set the FilterOnLoad property to No.

3. Still in design view, make sure the Visible property is Yes for the
Detail Section, as well as for the controls it contains.

4. In the Report Footer section, temporarily add a text box with Control
Source set to:
=Count("*")
This should show the number of records in the report, and will probably show
#Error if there are no records.

5. Run a compact/repair:
Office Button | Manage

6. If it still fails, open the report in Print Preview.
Open the Immediate Window (Ctrl+G), and enter:
? Reports![Report1].RecordSource
substituting your report name for Report1.
Double check that there are records matching this.

7. Set a different printer as the default, and try again. (Since Access uses
the metrics from the printer driver, a bad printer driver can mess up the
layout of the report.)

I'm assuming there's no chance that the data simply starts on page 2 of the
report?

 

[HJC]

Thank you for the quick response - the assumption you made was the problem -
it did not start on page 1 - for some reason the report started on page 6 -
how do I get it to start on page 1? I have never seen that. I appreciate
your prompt response - went through all of the other suggestions as I assumed
that it would (of course) start on page 1!

JC

Suggestions:

1. Have you applied Service Pack 1 for Office 2007 yet? If not:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5

2. Open the report in design view, and clear its Filter property (in the
Properties sheet.) You may also want to set the FilterOnLoad property to No.

3. Still in design view, make sure the Visible property is Yes for the
Detail Section, as well as for the controls it contains.

4. In the Report Footer section, temporarily add a text box with Control
Source set to:
=Count("*")
This should show the number of records in the report, and will probably show
#Error if there are no records.

5. Run a compact/repair:
Office Button | Manage

6. If it still fails, open the report in Print Preview.
Open the Immediate Window (Ctrl+G), and enter:
? Reports![Report1].RecordSource
substituting your report name for Report1.
Double check that there are records matching this.

7. Set a different printer as the default, and try again. (Since Access uses
the metrics from the printer driver, a bad printer driver can mess up the
layout of the report.)

I'm assuming there's no chance that the data simply starts on page 2 of the
report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have used earlier versions of Access and have been able to create and
print
reports; I created the first report in 2007 using the wizard yesterday - I
have done this several times and each time the report is blank - the
header
is there but no data - and I know there is data. I am guessing there is
something simple I am missing but I have been unable to find what that
missing step is. Any help would be appreciated!

 

[Allen Browne]

Perhaps there are some sections that have the Force New Page property set?

Or perhaps there are some blank records in the table?

You might also check for any Page Break controls on the report.

Or there could be code that's hiding controls, or expressions that are
evaluting to null.

 

[HJC]

Thank you so much; the original problem was because of errors in the
spreadsheet from which I imported the data - never thought of looking at a
series of extra records. I do appreciate the help greatly!