SubReports within Main Report, Hiding Blank Pages HELP 1

[PSBA11]

Hi

I have a main report which is filtered for each customer, the report contains about 7 or 8 subreports (Address Book, Feedback, Opportunities, Meeting Details etc) all relating to the chosen customer.

For some customers, there may not be data in the meetings subreport for example. In this case, when the report is viewed and printed it contains a blank page. I would like to get rid of this blank page.

All the Subreports properties have got can grow and can shrink set to "yes" and so are all the fields within the subreports.

How do I go about hiding the blank pages so that they are not previewed or printed??

 

[dhookom]

I would look for page break controls, keep together properties, and new page properties.

Duane
Hook'D on Access
MS Access MVP

 

[PSBA11]

Thank you for your reply.

I have page breaks in between every subreport, so that two subreports don't end up printing on the same page.

I have set all the "Grp Keep Together" Properties for each subreport to "Per Page"

I'm using access 2003 and I'm still getting the same problem.

 

[dhookom]

If you have page breaks then you will have page breaks. You can add code in the main report section containing the subreport to set the page break to invisible if the subreport doesn't return any records.

Duane
Hook'D on Access
MS Access MVP

 

[PSBA11]

thanks dhookom,

I'm afraid I'm not an expert in writing vba codes, what would the code look like and where would I place it??

 

[dhookom]

Caution, this is untested code that would be in the On Format event of the section containing the subreport. You will need to substitute your subreport control and pagebreak names.

[green]'you will need one line like this for each subreport/pagebreak[/green]
Me.PageBreakControlName.Visible = Me.srptControlName.Report.HasData

Duane
Hook'D on Access
MS Access MVP

 

[PSBA11]

This has worked perfectly, thank you very much!!