I'm an intermediate Access user. I have 3 summary reports that I would
like to combine on one report.
I tried to create a report in design view using 3 seperate subreport
boxes. Specifying the control source as the summary report.
Crucible_Summar y is one of the reports that I would like to see in the
sub report.
When I view the report I have forms set up to ask what beginning date
and end dates are required for each of the queries. So with the dates
being entered and the report opening.....it is blank! UGGHGHHH!
I already have a report that I have done just like this and it works
just fine. Is it possible the report name is the problem???
Thanks a ton, I have already spent all day pulling my hair out.
Peggy
7  3489 
The first thing to do is open your query in design view, click on the red
exclamation point to run the query and see if you get any records.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
<pe************ *@yahoo.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. . I'm an intermediate Access user. I have 3 summary reports that I would
like to combine on one report.
I tried to create a report in design view using 3 seperate subreport
boxes. Specifying the control source as the summary report.
Crucible_Summar y is one of the reports that I would like to see in the
sub report.
When I view the report I have forms set up to ask what beginning date
and end dates are required for each of the queries. So with the dates
being entered and the report opening.....it is blank! UGGHGHHH!
I already have a report that I have done just like this and it works
just fine. Is it possible the report name is the problem???
Thanks a ton, I have already spent all day pulling my hair out.
Peggy
The queries work, the individual summary reports work.
My goal is to put 3 working summary reports onto 1 page (They are small
enough that they would fit on 1 page). So I created a 4th report that
contains 3 sub reports (1 for each of the summary reports). When I
preview it, that report it is completely blank.
I've looked at all the properties and made sure everything is visible.
I can't specify a control source on the report properties because the
report is not drawing from 1 source....each of the sub report boxes has
the control source pointed to the right report.
Thanks,
Peggy
Does the source object property of each subreport control point to the
correct subform?
Are the LinkMaster and LinkChild properties of each subreport control blank?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
<pe************ *@yahoo.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. . The queries work, the individual summary reports work.
My goal is to put 3 working summary reports onto 1 page (They are small
enough that they would fit on 1 page). So I created a 4th report that
contains 3 sub reports (1 for each of the summary reports). When I
preview it, that report it is completely blank.
I've looked at all the properties and made sure everything is visible.
I can't specify a control source on the report properties because the
report is not drawing from 1 source....each of the sub report boxes has
the control source pointed to the right report.
Thanks,
Peggy
Yes, I have even scaled it back to just 1 subreport the control source
points to the correct report. But still nothing. The child and master
properties are blank.
It doesn't even display the label box for the subreport.
Thanks,
Peggy
I'm running out of ideas!
Open a code window and click on Tools - References. Look to see if any are
marked "Missing" and generally peruse to see if they are the same as other
applications.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
<pe************ *@yahoo.com> wrote in message
news:11******** *************@f 14g2000cwb.goog legroups.com... Yes, I have even scaled it back to just 1 subreport the control source
points to the correct report. But still nothing. The child and master
properties are blank.
It doesn't even display the label box for the subreport.
Thanks,
Peggy
PC Datasheet wrote: I'm running out of ideas!
I have one.
Put a MsgBox statement in the NoData event of the form. If it fires (and
displays the message), that may cause the Detail section to not display.
If that is indeed the point, base the report on a one-record recordset
(such as SELECT DISTINCT "a" FROM anytable)
--
Bas Cost Budde, Holland http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
I looked at the VBA for a report that works and there was a difference,
but the problem was actually something else. I finally figured it out.
The summary report properties had the "on open" and "on close"
properties set to look at the form that asks for the date range.....not
quite sure how that happened. But I emptied those fields and now my
data shows up on my report. Thanks for the inspiration.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Wayne |
last post by:
rr@kristin.school.nz (Wayne) wrote in message news:<7ec36840.0403301824.16f2cd9f@posting.google.com>...
> I have a subreport in my report and when it contains exactly one row,
> it works fine. In every other case, it displays all but the last row.
> The subreport grows large enough to show this last row but leaves it
> blank.
> Can anyone shed some light on this for me?
> Wayne
Since posting the original message I have had no replies....
|
by: Downstreamer |
last post by:
Design is as follows:
A form for the user to input criteria to be used as the where part of
the report's recordsource. This includes a multiselect list box as part
of the criteria selection.
The report is generated from a button on this form. In the button's
onclick event a where clause is built and assigned to a public variable.
Because of the multiselect listbox I use IN as part of the where
clause, for example, sqlstr = " ...
|
by: Keith Wilby |
last post by:
A97
I have a report/sub-report setup and for some records in the main report,
the sub-report is blank. I want to set the height of the sub-report to zero
where it is blank. I've set all the "Can shrink" properties to 'yes' but
I'm having trouble with the syntax referencing the text boxes on the sub-
report.
I get run-time error 2445 (you entered an expression that has an invalid
reference to the property form/report) on the first line...
|
by: Penguin |
last post by:
Using Access 97, I've created a grading sheet. To save space, the
subjects
are in vertical columns on a sub-report, like so:
Math Spelling Reading
N C T A A E
U A I C C X
M L M C C P
B C E U U R
E U S R R E
|
by: Jordan Fee |
last post by:
I'd like to perform some conditional formatting in the OnFormat Event of my
Parent Report. This works fine, until my subreports are blank, then the
invalid references start happening. I understand why, but can't figure out
how to trap/prevent these. I tried using the hasdata property, but this also
gives me an invalid reference. Arrrrrgh.
| | |
by: Frank |
last post by:
I am trying to manipulate a textbox display value of subreport from main
report's detail print() event.
The goal is this, if there is no record from database, replace the blank
space from textbox with message " No record found ".
I found the exact expression to reference my subreport textbox value
from main report, but when I tried to use IsNull() and Nz() function to
distinguish between blank and non-blank value, surprising it did not...
|
by: |
last post by:
hi,
i have a form on which a user can choose specific criteria such as dates
etc, in order to filter the report that is called from the form.
i do this by using the Where section of the docmd.openreport as follows
DoCmd.OpenReport stDocName, acPreview, , strWhere
where strWhere is a string dependant on the choices the user makes in the
|
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: Helen |
last post by:
vb .net 2002
crystal reports 9
Hello:
I have a subreport in the report footer of my main report.
When the subreport has no records to show, I have a message in the subreport Group Footer stating same.
It is followed by a blank page when the application is run, and I want to remove the blank page.
|
by: Helen |
last post by:
vb .net 2002
crystal reports 9
Hello:
I have a subreport in the report footer of my main report.
When the subreport has no records to show, I have a message in the subreport Group Footer stating same.
It is followed by a blank page when the application is run, and I want to remove the blank page.
|
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: 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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
|
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,...
|
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: 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();...
|
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.
| |
