I'm using AC2003. Sequence of events:
a. Tool -> Relationships
I show my tables & relationships and arrange them to fit landscape mode.
b. File ->Print Relationships
This generates a report in portrait mode with name/date etc. in report header section, an empty page header section, and diagram of relationships in detail section.
c. I go into setup, change to landscape orientation and adjust margins so my "print" is not too wide for the page.
d. I view report in design view. There is no grouping, no page breaks in report header, page header or detail sections, all page break controls are set to NONE. There is only one column.
e. However, when I look at the report in data view or print it, a blank first page is always generated. I thought maybe the problem was in the report header or page header, so I turned both of them off leaving only the detail section; but I still get the same result - a blank first page.
Thanks for any help in fixing this.
Janice
4 12886
...
e. However, when I look at the report in data view or print it, a blank first page is always generated. I thought maybe the problem was in the report header or page header, so I turned both of them off leaving only the detail section; but I still get the same result - a blank first page.
Hi. Check two properties of the detail section of your report. These are the Force New Page property, which should be None (Before Section will print a blank page), and Keep Together, which if it is set to Yes can cause a blank page to be shown when it is unable to keep the whole section together.
Although you mention that there are no groups, the report is presumably sorted on one or more fields, so check also in the grouping and sorting properties that Keep Together is set to No or With First Detail on each criterion, for the same reason as above.
These are the main causes of page throws I'm aware of. I would imagine your report does not contain event procedures on any of its sections which would force page throws, so if the keep togethers and force new page properties are OK I'd be stumped for another explanation for your difficulties.
-Stewart
Thanks for the reply, Stewart. I did check the two properties you mentioned and made sure Force New page was set to None and that Keep Together was set to No. I'm still getting the blank first page. There is no sorting or grouping as this report is automatically generated from Tool --> Relationships, and simply shows the tables and relationships that the user elects to "show" in the configuration the user has laid out.
This extra blank page is not a show stopper for me, just a minor nuisance and I don't have the time to pursue it right now. When I do have time, I may go back and start with a blank Relationships design and add tables one at a time and generating the report after each one to see if I still get a blank first page and if so what seems to cause it.
Thanks again for your advice. If you want to consider this thread closed, that's ok with me.
Janice
Hi. I tried this out on one of my more complex databases and ended up with 3 blank pages at the start. When I looked at the detail section of my relationship report it was 31cm long - way beyond the normal page limits.
I suspect that the wizard creating the report is stretching the detail section to fit the data, and that there is little in practice we can do about it.
Your pragmatic approach of treating it as a minor nuisance is a good one, I think.
-Stewart
Thanks for this last bit of information. It's always good to know someone else can independently duplicate the problem and your observation about the length makes sense. My report stretched over 3 - 11" x 8.5" pages (in landscape mode). I became so focused on the width issue that I didn't even consider the length.
Regards,
Janice
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Trogdor |
last post by:
I set up a server on an AMD 650 machine running gentoo linux.
I installed Apachie 2, MySQL 4.1 and PHP 4.3.11
I use another computer on my local net (192.168.0.x) to access the server as a...
|
by: k.mitz |
last post by:
Hi,
I have a PHP application that allows users to generate a .pdf report of
their database content. Normally, I've had to refresh a page to call
the script to generate the report, so there's a...
|
by: Bob |
last post by:
Hi,
I am using Access 2000 to print out an address book. I have designed
the report based on a database whose first record is not blank. In the
design there is a one line report header, a onle...
|
by: Grim Reaper |
last post by:
I know this is probably an easy question, but I could not find/figure it
out.
Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together....
|
by: noway |
last post by:
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...
|
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...
|
by: Wayne |
last post by:
I have a report containing 2 subreports. The subreports each contain a
chart. The whole thing easily fits on one page but a second blank page
is consistently being generated.
This has nothing...
|
by: netlady |
last post by:
Hi, can someone help me or share his or her idea why I am always getting a blank web page whenever I click the export button or the navigational next toolbar of the crystalreportviewer in .net ?
I...
|
by: Paulson |
last post by:
Hi guys ,
I got a problem.
I have made a pdf report using .rdlc in .net 2007.
The problem is that the report has 2 parts First it displays the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
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,...
|
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...
| |