How many nested subreports can you print?

[juicybeasty]

I have a situation where I have a report with a subreport, and on that subreport are another 2 subreports. Therefore there are nested 2 levels of subreport.

When I print the main report it prints the first subreport but leaves blank spaces where the other 2 should be. Clearly this is not good!

Can I get it to print everything? I'm using Access 97.

 

[namliam]

Are you sure the 2 'invisible' subreports contain records?

I have heard of succesfull 5 level reports (did not build them myself)

Regards

The Mailman

 

[juicybeasty]

They do, yeh.

Because when I print the first subreport it shows the two subreports in that one with data in them. It's just when I print the main report it doesn't work.

Is it because I created the reports and subreports by saving the form and its subforms as reports? Because the same think happens when I try to print the form.

 

[namliam]

Sorry dont know... I never created reports from forms....

 

[Rich]

You have to create the subReports separately, and change the source object for the subReport on the Main Report to these subReports and not the form, you should also remove any code behind the report that was originally on the Form.