I want page break functionality after every sub reports

[meena]

I am creating a report with multiple sub reports. I need each of these sub report to be printed on a new page. How do I do this. Please help.

[June7]

Could try a page break control.

[meena]

And how do I do that.. I am sorry very very new to access.

[meena]

I have put all sub reports in one main report. I have passed one parameter called "Report Name" which contains the list of sub reports along with "All" option. on the basis of this parameter the subreport get displayed. Now I want page break functionality after every sub reports. And if the subreport doesn't contain any data than it should not put any blank page in between. Can any one help me with this?

[June7]

Just like a textbox, it's a control on the ribbon design tab. In 2010 it's between the OptionGroup and Combobox controls, looks like 2 pages with an arrow between them. Click and drag to the form.

[June7]

For not producing blank page, I had this issue and finally decided to allow the page with a label stating "No data".

Here is what I do. Have label on report with caption. If subreport does not have data, then display the label.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.lblOU.Visible = Not Me.ctrOU.Report.HasData
Me.lblCO.Visible = Not Me.ctrCO.Report.HasData
Me.lblRC.Visible = Not Me.ctrRC.Report.HasData
End Sub

Or maybe this will work for you http://www.tech-archive.net/Archive/.../msg00262.html

[meena]

Just like a textbox, it's a control on the ribbon design tab. In 2010 it's between the OptionGroup and Combobox controls, looks like 2 pages with an arrow between them. Click and drag to the form.

Thanks a lot... It worked as I wanted ... Thank you :-)