By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

subreport blank

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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

Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a
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

Nov 13 '05 #6

P: n/a
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
Nov 13 '05 #7

P: n/a
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.

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.