Subreports not printing, but show up fine in Report View

[TFG]

I have the same problem. After reading this post, I was able to fix this problem with my query fields by clearing the "link Child Field" in properties. But I still have this problem with some fields that are directly linked to a table. Thanks for the tips so far.

 

[CFAU]

I had a similar problem. I changed the "Layout for Print" property on the main report to "no" and the subreport printed

 

[Mhebor]

I have a database that was developed using office 2003 and in the database there are reports with subreports. They work fine with 2003, but when bringing them up in 2007, two subreports do not show up in print preview. If I right click the report and choose "Report View", one of the subs do show up and the other looks like it is in design view. Any help would be appreciated.

 

[terry.ternan]

I've been agonizing over the same issue ... and I think I found the answer.

1) Open the main report in design view and properties
2) Select the subreports
3) Set Filter on Empty Master to "No"
4) Save changes and test.

Worked for me, though I have no idea why.

 

[MSPeters]

I have tried I believe all of the suggestions in this thread. I have a simple report with simple sub reports that link with a single field. I have much more complex reports with many many more subs that do run. I can see my data after a few second in report view but print preview or printing does not show any sub report. It is almost as if printing or print previewing is not allowing enough time for the subreports to render.

Anyone else have any suggestions?

 

[The John Rambo]

I had the same problem where the subreport did not show when printed or exported to any other format but showed on my screen (preview). I could print the sub-report/export by itself with no problems.

I systematically deleted the controls on the subreport until the subreport showed up when printed. I found that there was a control with the same name as the "Link Child Fields" and "Link Master Fields" to the Main Report which I think was 'confusing' Access when printing. I changed the name of the control and the sub report now prints.

I hope this helps in some way.

 

[andydlindsay]

I have tried I believe all of the suggestions in this thread. I have a simple report with simple sub reports that link with a single field. I have much more complex reports with many many more subs that do run. I can see my data after a few second in report view but print preview or printing does not show any sub report. It is almost as if printing or print previewing is not allowing enough time for the subreports to render.

Anyone else have any suggestions?

I was having this exact same problem: the subreport looked brilliant in layout view and report view, but in print preview (and on the subsequent printout) only the first record would appear. My subreport was exactly lined up with the edge of the detail section of the main report (for clarity: my subreport was within the header of the main report). When I moved the subreport away from the detail section (via ctrl + up arrow), it started displaying fully in print preview.

This solution may not solve everyone's problems, but it worked for me.

 

[SueBK]

I realise this is a very old thread, but I found it because I had the same problem - subreports showing up in some views, but not printing. I seem to have worked out my issue:
My report is opened via a button on form. The form has a combo-box to choose which project I want. The button code says to filter the report against the choosen project.
HOWEVER, in the queries behind my subreports I had a "forms!frmStartUp!Combo02" filter for the project (was handy while I was designing).
When I click any button on my 'frmStartUp', combo02 (my project selector) resets to blank (I've never worked out how to prevent this).
Because the filter data is available to queries when I click the button, the report appears populated. When I click print, the data is no longer available (ie the subreports have no data, so naturally they print blank).
Since the code filters the main report on the project no, and the subs are linked by that project no, I've now removed the extra filter from the subs' queries. And it all seems to be working.

 

[SusiV]

Try Compact and Repair.
That worked for me.

 

[SusiV]

...and if Compact and Repair doesn't work, try this:

Delete the image.
Save and close the report.
Open the report and place a new image where the old one was.

Experiment with these two suggestions whenevr the print preview "misbehaves".
Seems to work fine, at least for linked images.

Would be nice to get an explanation.