Topics Search

Force New Page

Force New Page
Views: 72
I have a report with Force New Page, what I don't want to happen is if its the last record in the group report then I do not want to force a new page. Want to try keeping that group together.

I have 3 groups for footers below is the groups which I have set force new page after section


At the moment after the grouping for customers its creating a new page after Order group where I would like the customer total on the same page as it was the last record for that group
Sponsored Links:

More topics


Grouping on a Report

Can someone please help? The attachment shows the format I would like except that when you look at page 4 you will notice Class 183 and the headings Cage and Place are on this page but the actual boxes for these titles are on the next page. I would like to force that class to the next page (or maybe its new column)but cannot manage to. Similarly page 11 Class 366 I would like to force to a new column to be above its respective cage numbers. The print out is set for an A5 page

How to force a new page?

I have a report where each record is on a new page. But the records are different lengths, so sometimes a new record will start on the same page as the previous record.

Force Report Breaks

I have a report that gives a full report by a group number entered. I would like to break that group into 10 reports. I have a calculated field in the header that shows the total # of records divided by 10 but am unable to find a way to force a new report after printing ? # of lines.

I would like to have a new report w/header and page number starting at 1 again.

Force a page break based on the first letter of the LastName field in a report

In Access 2003/XP/2000/97, I have a database and I'd like to insert a page break in a report listing names and addresses. For example: page break after all the last names that start with the letter A and so forth.

Always get one extra, blank page

I have a very simple, one-page report (it only contains an image of a grid pattern) with a Report Header and one small sub-report that sits in one corner of the grid and tells me what to plot onto the grid.

Everything is within the margins I've allowed (Narrow Margins.) I've checked the report header, footer, and detail. In each of those cases the "Force New Page"is set to "None."

However, every time I print this, I end up with a printed page and a blank page.

How can I eliminate the blank page, I'm using Access 2007 and Windows 7 Professional 64-bit.

Forced New Page In Access Report

I have an access report where I need to force a new page after a section is finished. However, after the last record is printed, that section forces a final, blank page. Does anyone know of a way to prevent the last forced page if it has encountered the final record?

Sorting/Grouping in Rpts: Group Headers

I have created a report that I am sorting/grouping by Patient#. I am using a group header (header for each patient). However, it is splitting the page after the group header and before the Detail. I've tried everything. page is not too large, no force new page selected

How to force a new page when sub report exceeds allocated space

I have a sub report (invoice details) inside a report (invoice header and footer). The sub report is limited to a box on the pre-printed form so I set Can Grow to No. If the lines in the sub report exceed the amount of space allocated to it, it just stops formatting details (or at least I can't see them).

I would like it to trigger a new page for the report and then continue printing the sub report on the next page.

Blank pages in reports?

I know the answer to this is probably very simple, but it's driving me nuts! I have a report that I have grouped by process. I have it set to force a new page Before Section. It is inserting a blank page, with just my report header and footer, no data, between each grouping. How can I get rid of the blank pages

Missing data in Access sub-report

I have a report that contains 7 sub-reports. If the last sub-report has no data, and the 6th sub-report does have data, then Access is only printing out the first page of the 6th sub-report. I can force all the 6th sub-report to print if I add data to the 7th sub-report. But, of course, I don't want to see this sub-report since there should be no data using the report criteria I'm providing.

If I run the 6th sub-report on its own then then all the data is displayed properly.

Any ideas on how to force all the data to display without requiring a blank 7th sub-report to display?

I have attached an Access 2003 MDB that shows the bug. If you run PriorityRpt, which is the container for the sub-reports you will see that the report "Closed to Charges Notification Received" will only have one page. However, if you run the sub-report PriorityRptCloseToCharges, you will see that sub-report should be 4 pages long