473,763 Members | 5,466 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Blank pages in a report

I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry
Nov 13 '05 #1
6 4704
no***@here.com wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.
Nov 13 '05 #2
Hi there,

Maybe a natural page break is occurring within a line or two of your page
break control. Suggest
removing your page break control and see what happens.

HTH -Linda
<no***@here.com > wrote in message
news:72******** *************** *********@4ax.c om...
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry

Nov 13 '05 #3
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.co m> wrote:
no***@here.c om wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.


Nov 13 '05 #4
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.co m> wrote:
no***@here.co m wrote:
I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry


Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.


Nov 13 '05 #5
I'd recommend losing the page break and setting your group header's
ForceNewPage property to Before Section.

<no***@here.com > wrote in message
news:7m******** *************** *********@4ax.c om...
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
Thanks, but that was the first thing that I checked. The column size
is good and is smaller that the page width.

On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.co m> wrote:
no***@here.co m wrote:

I have greated a report and have included a page break in it. The
report breaks were it is supposed to but then it creates a blank page
between the two pages. Since this report will print out approx 20
pages (without the blank pages) it is large waste of paper. I have
tested the report by setting the data source so that only one page
will print and all the data fits on page. I have checked all the
printing parameter, set the print magins and made sure that the report
fits on one page.

ANy ideas as to what I can do?

Thanks Harry

Check your page size. The fields may exceed the length of your column
(File/PrinterSetup)

Make sure your fields placement don't exceed the column width.

Nov 13 '05 #6
Thanks alot.
That seems to do the trick. I will have to do some more testing but I
think it will be good.

Thanks again,
Harry

On Sun, 30 Jan 2005 12:29:27 GMT, "MacDermott " <ma********@nos pam.com>
wrote:
I'd recommend losing the page break and setting your group header's
ForceNewPage property to Before Section.

<no***@here.co m> wrote in message
news:7m******* *************** **********@4ax. com...
Linda,

The does not print out any blank pages when the page break is removed.
There is group header on the report based on the field ClientNumit is
grouped on each value and keep together is set to yes. The problem is
that while most pages will seperate correctly, that is each page will
start with a new ClientNum and grouyp header, some pages will have
part of the previous page before the group header. That is why I put a
page break on the report. It solved that problem but now creates this
new one.

Harry
On Sun, 30 Jan 2005 11:48:18 GMT, no***@here.com wrote:
>Thanks, but that was the first thing that I checked. The column size
>is good and is smaller that the page width.
>
>
>
>On Sun, 30 Jan 2005 09:03:57 GMT, Salad <oi*@vinegar.co m> wrote:
>
>>no***@here.co m wrote:
>>
>>> I have greated a report and have included a page break in it. The
>>> report breaks were it is supposed to but then it creates a blank page
>>> between the two pages. Since this report will print out approx 20
>>> pages (without the blank pages) it is large waste of paper. I have
>>> tested the report by setting the data source so that only one page
>>> will print and all the data fits on page. I have checked all the
>>> printing parameter, set the print magins and made sure that the report
>>> fits on one page.
>>>
>>> ANy ideas as to what I can do?
>>>
>>> Thanks Harry
>>
>>Check your page size. The fields may exceed the length of your column
>>(File/PrinterSetup)
>>
>>Make sure your fields placement don't exceed the column width.


Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4538
by: L Mehl | last post by:
Different users of the app will want or not want to see report footer ( appears as a separate page). I can make the section invisible with a DLookup of a Y or N value from a 'parameters' table Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer) Reports!rptValuationDetail.Section(acFooter).Visible = _ DLookup("", "sysparms", " = " & Chr(34) & "printReportGrandTot" & Chr(34)) = "Y"
6
5540
by: Melissa | last post by:
Does anyone have a generic procedure for adding blank lines to reports like Sales details, PO details and/or Orders details. The procedure would need to count the number of line items, determine the remaining page to fill and print blank lines with the same number of fields as the line items. In addition, if there were a long list of line items that carried over to a second and possibly more pages, to print blank lines at the last page. The...
4
10963
by: Nhmiller | last post by:
Access seems to always generate a second page, which is blank, to my one page report. How do I delete the second page? Thanks. Neil Cat Paintings At Carol Wilson Gallery http://www.carolwilsongallery.com
4
2437
by: Robert McClenon | last post by:
I am having a minor but annoying problem with some reports in Access 2003. (I had the same problem with Access 97, so it isn't version-dependent.) Some of the reports that I originally developed with the Report Wizard but have since edited now print so that there is a blank page after each actual page. I assume that this is because the page size is slightly larger than the Page Setup for the LaserJet. I assume that I need to adjust some...
2
1888
by: Raul Medina | last post by:
I am trying to print the same visual basic report multiple times in my VB 6.0 application using the command <reportObject>.printReport False, rptRangeAllPages. The only thing that differs between each report is a label that get modified. The result is only the last report processed is printed with the other reports producing blank pages. If I put a delay so that each printReport command is called only after the preceding report is...
1
10588
by: Karen Hill | last post by:
X-No-Archive:yes I have a report that when I view it gives me a blank page after a page with data. For example in the footer, it says I have 2 pages (page 1 of 2), yet when I use the arrow key there are actually 4. The first one has the data, and the next one is a blank page, and the page after has data and the next one is blank. I have everything set to can grow and shrink.
1
2882
by: jj | last post by:
I created a dynamic report and the fields is displayed base on the query. The report contains about 34 fields so if the query has 34 fields, all 34 fields in the report shows up. But if the query has 10 (which most of them have) fields, the report only shows 10 fields and hides the rest. What happen is that when I go to print preview, its shows the pages that have the fields and the blank page. The blank page infact are the hidden fields....
4
3157
by: Mal Reeve | last post by:
Hello, I have a report that has only 2 levels of grouping. The detail section is simply 1 large block for a memo field. I am finding that on some occasions the report errors and generates hundreds (perhaps even an infinite loop...I have to break the system to stop the report generating) of pages. While I'm not 100% I think this may have something to do with the detail
1
3323
by: maryanncanor | last post by:
Hi everyone, My problem is whenever I export a report to a textfile. The output textfile have blank spaces. Here is my query: SELECT ( & '|' & & '|' & ......................and so on .........................AS EXPR1 FROM ;
0
10148
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9938
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9823
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8822
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7368
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5270
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3917
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2794
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.