473,382 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Report Containing Subreports Generates An Extra Blank Page

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 to do with the page width being too large because it
isn't, and the second blank page displays the report header and footer.
I can reduce the depth of the subreports so that they only take up one
half of the first page's depth, but the second blank page complete with
header and footer is still being produced.

If I remove the bottom subreport the problem disappears dispite the
fact that there is more that enough room on the first page to
accomodate the content.

Does anyone have any ideas as to what could possibly be causing this
behaviour? I've tried everything that I can think of without success.

Jan 25 '07 #1
3 9137
I have had this problem when using the wizard? Anyway it was almost
always a result of the workspace being just a little to wide (I know
it's actually fine) so just drag the right edge of your workspace over
to the left a little bit, click to view the report and then go back to
the design view, you will notice it moved the border back. Now your
blank page should be gone.

On Jan 25, 12:16 pm, "Wayne" <cqdigi...@volcanomail.comwrote:
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 to do with the page width being too large because it
isn't, and the second blank page displays the report header and footer.
I can reduce the depth of the subreports so that they only take up one
half of the first page's depth, but the second blank page complete with
header and footer is still being produced.

If I remove the bottom subreport the problem disappears dispite the
fact that there is more that enough room on the first page to
accomodate the content.

Does anyone have any ideas as to what could possibly be causing this
behaviour? I've tried everything that I can think of without success.
Jan 25 '07 #2
Thanks for the reply, but this is not the problem. When the workspace
is too wide the extra page is generally blank. Mine contains the
header and footer. Besides this, if I remove the bottom subreport the
extra page disappears.

Jan 25 '07 #3
Can I suggest you check the width/height of the subreport and its placement
on the main report. Make sure the height of the subreport is small and "can
grow"
"Wayne" <cq*******@volcanomail.comwrote in message
news:11*********************@a34g2000cwb.googlegro ups.com...
Thanks for the reply, but this is not the problem. When the workspace
is too wide the extra page is generally blank. Mine contains the
header and footer. Besides this, if I remove the bottom subreport the
extra page disappears.

Jan 29 '07 #4

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

Similar topics

4
by: deko | last post by:
I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm,...
6
by: David B | last post by:
I have a report with 2 sub reports on it. The report is an invoice and the sub reports are dropping data onto the invoice. This worked fine if generating 1 invoice at a time. I am trying to create...
3
by: Edward | last post by:
ACCESS 2k I need to design a report based on a rota system for staff at various shops. The data is effectively stored in a single table, along the lines of: Initials (e.g. BH, FG, RM etc.)...
1
by: Tim Frawley | last post by:
I have created a Crystal Report with five subreports to represent datagrids on our dataentry application. The largest datagrid is the last item on the report. When empty this last subreport will...
1
by: Nadia Daems via .NET 247 | last post by:
I desingned a report with several subreports to use in my application. Normally each subreport have to start on a new page. I did this by making a diffrent section for each subreport and selecting...
0
by: Henry | last post by:
I have written an ASP/VB.Net application via VS 2003 (Crystal V9) that uses MS Access 2000 as its database. I can export reports that have no linked sub reports for printing. However, I'm unable...
2
by: report help | last post by:
I have a report that is supposed to be two pages. The first page should contain the header, some data from a query, and the footer. The second page should contain the header, two subreports, and...
2
by: harley.mcnerthney | last post by:
I have an Access 2007 problem and I would just like to know if there is some sort of solution out there. The problem is, when I build a report that will 99% of the time be one page or less maybe...
6
by: Brett Barry: Go Get Geek! | last post by:
Hello, I have a main report with a Record Source, a DateToday table, that has the current Month and Year. I have about 60 queries, each pulling different data via ODBC, that I am creating...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
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
1
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...
0
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 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.