Page Break between reports

[regava]

ACCESS 2000 - I have a report that consists of 10 different subreports. I need to place a Page Break at the end of each subreport so that the next subreport will be positioned at the top of page. Any help is appreciated.

 

[Remou]

Does the Page Break control not suit?

 

[regava]

Remou sorry but I do not understand your question.
All I want to do is start each subreport on a new page which is not what is doing now. Thanks.

 

[Remou]

Use the Page Break control it looks like this: ...
Add a page break after each subreport.

 

[regava]

Remou, in your reply you said to ad a page break after each subreport. Can you explain what do you mean by "..." and how to implement it? Thanks

 

[Remou]

Open the report in design view. Look at the ToolBox. There is a control called Page Break. You can find it by moving the mouse over each of the controls. Click on the Page Break control and then 'draw' a page break on your report where you want it.

 

[regava]

Remou thank you for your reply. I was not able to get back to this problems because I was pulled to do something else.
Let me be more specific. I have a report that is broken into 10 subreports. What I would like to happen is that each subreport start on a new page. To that effect I inserted page break at the end of each subreport in the report footer section -- No luck. I removed them then I inserted the page break at the beginning of each subreport in the report header section -- No Luck. I looked into MS help but I could not find any help. Any suggestion?
I do appreciate any information. Thanks.

 

[Remou]

Do not insert the page break in the subreports. Insert the page breaks in the main report between the subreports.

 

[regava]

Thanks. That did it. Much appreciated.
Have a wonderful weekend.

 

[dz0nrf]

This usually works, but some on my sub-reports might sometimes be empty (no data), and this results in printing blank pages. What I need is a conditional page break that is only used after each sub-report if the sub-report has data to print.

 

[Remou]

Have a look at the HasData property. If you get stuck, please start a new thread.

 

[dz0nrf]

Useful thoughts. I guess that 'hasdata' is a property within Access 2007; I am using 2003 at present. I tried putting page-breaks between sub-reports, then using the 'on no data' property to call a macro to 'hide' the page breaks after each sub-report. This failed. I'll give this some further consideration. Thx.

 

[Remou]

HasData has existed since at least 2000. It is unfair to hold a discussion in regava's thread, hence my request to post in a new thread. Please do not post back in this thread.

If Me.SubReportControlName.Report.HasData Then
<..>

 

[Hosacans]

Hi All,

I have another question on report formatting, I have 3 sub reports each with different widths, and one of the sub reports is too wide for a letter size layout, even with margins set to zero. Normally i would adjust the content of the subreport to fit the main report. But in this case, i cant find any more space to give, and the fonts have already become incredibly small.

I know that theres a way to fit the sub report onto the main report by shrinking it. but I cant find the controls for it. I have another database (not done by me) that has the same situation but was able to shrink the wider subreport to fit the main report. (the sub report is 15"(w) by 4", and was able to fit into a letter size landscape layout). does anyone know the means to achieve this? and I dont think Can Grow and Can Shrink are the options controlling that.

Also, sorry for divert this thread, somehow my start new thread option is not working and i really need to finish this report.

Thanks
Hosacans