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_Summary 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 3468
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******@pcdatasheet.com www.pcdatasheet.com
<pe*************@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.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_Summary 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******@pcdatasheet.com www.pcdatasheet.com
<pe*************@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.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******@pcdatasheet.com www.pcdatasheet.com
<pe*************@yahoo.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.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...
|
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.
...
|
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...
|
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 ...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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...
| |