Subreports Not Visible in Main Report

  • Thread starter Thread starter Amber
  • Start date Start date
A

Amber

I have a main report with several subreports in it. The
subreports are based off of queries. I have date criteria
for the main report so that only "date specific"
information will show in the main report. My problem is
that when I run the main report, there is no information
that shows up from the subreports. Its like the
subreports are blank. When I run just the subreport on
its own, the information shows up, so there is info in
the subreports. I do have the parent/child fields
linked. And if I put a subreport that is NOT based on a
query into my main report, the information shows up...but
then its not date specific like I want.

What can I do to have my "query based" subreports show in
my main report?
 
To have your subreports display, you can't filter out all the records from
displaying. So, if you don't see the subreports then either the subreport's
record source query or the link master/child properties.
 
The subreports record source query and the link master/child properties are
both correct. Does anyone have any other ideas?

I have done this before in Access 97, but now I am using Access 2000 and it
will not work properly.

Thanks
 
How is the criteria set for the subreport(s)? Do you have any code running
in your report or subreports?
If everything is as you state then I can only suggest there is some
corruption since I have never experienced or heard of this issue before.
 
The subreport is based on a query. In the query, I have 3 fields, one of
which is a date field and has the following criteria: Between
[forms]![Paramform]![StartDate] And [forms]![Paramform]![EndDate]. I have an
unbound form named Paramform with 2 controls, StartDate and EndDate.
The main report has some code, for the close event DoCmd.Close acForm,
"Paramform" and for the open event DoCmd.OpenForm "Paramform", , , , ,
acDialog.

Without the "date criteria" in the subreport, the main report prints fine.
When I put the date criteria back in my query/subreport, then my main report
prints blank. I need to be able to print the main report for specified date
periods.

Thanks
 
Open and fill in the dates prior to the report opening and close it or hide
it after the main report closes.

--
Duane Hookom
MS Access MVP
--

Amber said:
The subreport is based on a query. In the query, I have 3 fields, one of
which is a date field and has the following criteria: Between
[forms]![Paramform]![StartDate] And [forms]![Paramform]![EndDate]. I have
an
unbound form named Paramform with 2 controls, StartDate and EndDate.
The main report has some code, for the close event DoCmd.Close acForm,
"Paramform" and for the open event DoCmd.OpenForm "Paramform", , , , ,
acDialog.

Without the "date criteria" in the subreport, the main report prints fine.
When I put the date criteria back in my query/subreport, then my main
report
prints blank. I need to be able to print the main report for specified
date
periods.

Thanks



Duane Hookom said:
How is the criteria set for the subreport(s)? Do you have any code
running
in your report or subreports?
If everything is as you state then I can only suggest there is some
corruption since I have never experienced or heard of this issue before.
Click to expand...
Click to expand...
 
Do you mean open my form, enter the dates, and then run my main report? Or
where should I enter the dates before my report opens?

Duane Hookom said:
Open and fill in the dates prior to the report opening and close it or hide
it after the main report closes.

--
Duane Hookom
MS Access MVP
--

Amber said:
The subreport is based on a query. In the query, I have 3 fields, one of
which is a date field and has the following criteria: Between
[forms]![Paramform]![StartDate] And [forms]![Paramform]![EndDate]. I have
an
unbound form named Paramform with 2 controls, StartDate and EndDate.
The main report has some code, for the close event DoCmd.Close acForm,
"Paramform" and for the open event DoCmd.OpenForm "Paramform", , , , ,
acDialog.

Without the "date criteria" in the subreport, the main report prints fine.
When I put the date criteria back in my query/subreport, then my main
report
prints blank. I need to be able to print the main report for specified
date
periods.

Thanks



Duane Hookom said:
How is the criteria set for the subreport(s)? Do you have any code
running
in your report or subreports?
If everything is as you state then I can only suggest there is some
corruption since I have never experienced or heard of this issue before.

--
Duane Hookom
MS Access MVP


The subreports record source query and the link master/child properties
are
both correct. Does anyone have any other ideas?

I have done this before in Access 97, but now I am using Access 2000
and
it
will not work properly.

Thanks

:

To have your subreports display, you can't filter out all the records
from
displaying. So, if you don't see the subreports then either the
subreport's
record source query or the link master/child properties.

--
Duane Hookom
MS Access MVP


I have a main report with several subreports in it. The
subreports are based off of queries. I have date criteria
for the main report so that only "date specific"
information will show in the main report. My problem is
that when I run the main report, there is no information
that shows up from the subreports. Its like the
subreports are blank. When I run just the subreport on
its own, the information shows up, so there is info in
the subreports. I do have the parent/child fields
linked. And if I put a subreport that is NOT based on a
query into my main report, the information shows up...but
then its not date specific like I want.

What can I do to have my "query based" subreports show in
my main report?
Click to expand...
Click to expand...
Click to expand...
 
Yes, open the form first and enter the dates. Then open your report while
the form is still open.

--
Duane Hookom
MS Access MVP
--

Amber said:
Do you mean open my form, enter the dates, and then run my main report? Or
where should I enter the dates before my report opens?

Duane Hookom said:
Open and fill in the dates prior to the report opening and close it or
hide
it after the main report closes.

--
Duane Hookom
MS Access MVP
--

Amber said:
The subreport is based on a query. In the query, I have 3 fields, one
of
which is a date field and has the following criteria: Between
[forms]![Paramform]![StartDate] And [forms]![Paramform]![EndDate]. I
have
an
unbound form named Paramform with 2 controls, StartDate and EndDate.
The main report has some code, for the close event DoCmd.Close acForm,
"Paramform" and for the open event DoCmd.OpenForm "Paramform", , , , ,
acDialog.

Without the "date criteria" in the subreport, the main report prints
fine.
When I put the date criteria back in my query/subreport, then my main
report
prints blank. I need to be able to print the main report for specified
date
periods.

Thanks



:

How is the criteria set for the subreport(s)? Do you have any code
running
in your report or subreports?
If everything is as you state then I can only suggest there is some
corruption since I have never experienced or heard of this issue
before.

--
Duane Hookom
MS Access MVP


The subreports record source query and the link master/child
properties
are
both correct. Does anyone have any other ideas?

I have done this before in Access 97, but now I am using Access 2000
and
it
will not work properly.

Thanks

:

To have your subreports display, you can't filter out all the
records
from
displaying. So, if you don't see the subreports then either the
subreport's
record source query or the link master/child properties.

--
Duane Hookom
MS Access MVP


I have a main report with several subreports in it. The
subreports are based off of queries. I have date criteria
for the main report so that only "date specific"
information will show in the main report. My problem is
that when I run the main report, there is no information
that shows up from the subreports. Its like the
subreports are blank. When I run just the subreport on
its own, the information shows up, so there is info in
the subreports. I do have the parent/child fields
linked. And if I put a subreport that is NOT based on a
query into my main report, the information shows up...but
then its not date specific like I want.

What can I do to have my "query based" subreports show in
my main report?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top