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.
3  9150 
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...@volc anomail.comwrot e:
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.
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.
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*******@volc anomail.comwrot e in message
news:11******** *************@a 34g2000cwb.goog legroups.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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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, "frmReportOptions" <== popup form
This is the error I get when I try to move to the last page of the report
*after* closing the popup:
"This expression is typed incorectly, or is too complex to be evaluate...."
|
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 a run of invoices. I would like the appropriate data for
each custid from each sub report to be on the same page. The nearest I can get
is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK
|
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.)
Day (e.g. Monday, Tuesday etc.)
Shop (e.g. Shop1, Shop2 etc.)
StartTime (e.g. 8, 13 etc.)
|
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 print on
page one of the report about halfway down the page.
The problem is when this subreport has more than 50 rows it grows off
the page. Not a problem as it will print all the pages necessary for
this subreport but it starts the report on...
|
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 the option "New page before" for each section.
When a subreport is blank, both the subreport and the section are suppressed but the new page isn't, so there are empty pages in my report.
Because the reportheaders of the subreports are suppressed,...
| | |
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 to export reports
that have linked subreports. I receive (a "Missing parameter field
current value") on the following statement:
Me.crReportDocument.Export()
The main report requires 4 parameters. The linked reports do not
require any...
|
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 the footer.
Right now, the report is on 4 pages. The first contains the header,
query data, and the footer ... this page is fine. The second page has
no header, but does contain the two subreports. The 3rd and 4th pages
contain the query data...
|
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 even a
half
page. I end up with a giant space in the middle of my report. I
want
to fill that space with empty records but the records must only be
enough to fill the page and still leave the report foot at the bottom
of the last page. Those...
|
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 subreports that go on the
main report. The problem is that when I run the report the data shows
on the screen but not the print preview. I am aware that the main
report is not linked to the subreports because of the Link Master,
Child Fields issue....
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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...
| | |
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
