Report/subreports working on-screen but not printing

[JR]

I have a report with three subreports which works fine on-screen and in
print-preview, but shows only subreport headers when saved to pdf or printed
in hard-copy. Is it possible that the subreports are too complicated for
printing? Thanks much!

 

[Duane Hookom]

Are you getting any criteria from controls on a form? Are you closing the
form with code contained in your report?

 

[JR]

The subreport is built on a query wherein I've set one criteria to restrict
the amount of data showing. All other tables, queries and subreports are
closed when I'm attempting to run the report. Strangely, I have four other
comparable sized reports in the database that are all working as expected.
One of them contains more subreports than this one, so I really don't think
it can be a capacity issue. I've been thru the page set-up, checked all the
obvious master/child relationships, and it's still not working!

 

[Duane Hookom]

Could you provide some details/sql of your main and subreports. This might
help explain how "I've set one criteria to restrict the amount of data
showing".

 

[JR]

Thanks for your help Duane - you must be bored today! All the main reports
I've built are based on (and sorted by) an area description called "GMA" -
this information is in the report "GMA header"; this is my Master. The
subreports contain various notes and numbers relevant to each GMA, but on a
finer detail - smaller chunks of area - but each connected back to the main
GMA. So "GMA" in each Subreport is the Child. My larger list of GMAs is
sorted by four groupings - 1, 2, 3 or 4. So, I built a query to select only
3 or 4, and this provides the info necessary to build the main report "GMA
header". Since everything appears to work on-screen, but not printing to PDF
or printer, our IT person is guessing that I've simply got a page set-up
complication somewhere. However, we're both now getting this messsage: This
expression is typed incorrectly, or it is too complex to be evaluated. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to variables.
(Error 3071). I'm in the midst of going back thru queries that are working
and comparing them to these not working and trying to find any differences.

 

[Duane Hookom]

I'm still hoping you can provide the SQL properties of your report record
sources. Also, it might help if you would provide information on any code the
opens/closes the report or a form related to the report or its record source.

 

[JR]

Thanks Duane - delving into a world I'm not totally familiar with now. In
summary, main report has three subreports. Main report fields come from one
table. Each of the subreports come from their own tables/queries where I
have sorted the info I'm looking for. Here is the sql for the main report.
The sql for the subreports are long - do you really want that??!!

SELECT [*List - GMAs].MgmtRegion, [*List - GMAs].GMA, [*List -
GMAs].GMA_Name, [*List - GMAs].Short_Description, [*List - GMAs].Rotation
FROM [*List - GMAs]
WHERE ((([*List - GMAs].Rotation)=3 Or ([*List - GMAs].Rotation)=4))
ORDER BY [*List - GMAs].GMA;

 

[Duane Hookom]

You stated:
"Each of the subreports come from their own tables/queries where I have
sorted the info I'm looking for"

I don't know if you actually mean "sorted" since sorting is just placing in
a particular order. All sorting should be performed in the report sorting and
grouping dialog, not the query. If you really meant "filtered" then you need
to explain how the filtering is performed.

Also, your original statement was "shows only subreport headers when saved
to pdf or printed
in hard-copy". What do you mean by "subreport headers"? Do you mean the
report header sections of the subreports?

--
Duane Hookom
Microsoft Access MVP

Thanks Duane - delving into a world I'm not totally familiar with now. In
summary, main report has three subreports. Main report fields come from one
table. Each of the subreports come from their own tables/queries where I
have sorted the info I'm looking for. Here is the sql for the main report.
The sql for the subreports are long - do you really want that??!!

SELECT [*List - GMAs].MgmtRegion, [*List - GMAs].GMA, [*List -
GMAs].GMA_Name, [*List - GMAs].Short_Description, [*List - GMAs].Rotation
FROM [*List - GMAs]
WHERE ((([*List - GMAs].Rotation)=3 Or ([*List - GMAs].Rotation)=4))
ORDER BY [*List - GMAs].GMA;

I'm still hoping you can provide the SQL properties of your report record
sources. Also, it might help if you would provide information on any code the
opens/closes the report or a form related to the report or its record source.

 

[JR]

Yes, sorry! This is getting complicated! I placed "sorts" in the queries; I
have removed them and just sorted the reports. I also filtered the queries
for the particular records I was looking for in the reports. For example:

SELECT [*List - Beds with GMA].GMA, [*List - Beds with GMA].StatAre, [*List
- Beds with GMA].SubArea, [*List - Beds with GMA].BedCode, [*Notes by
2-Bed].Season, [*Notes by 2-Bed].Notes, [*Notes by 2-Bed].Quota
FROM [*List - Beds with GMA] LEFT JOIN [*Notes by 2-Bed] ON ([*List - Beds
with GMA].StatAre = [*Notes by 2-Bed].Area) AND ([*List - Beds with
GMA].SubArea = [*Notes by 2-Bed].Subarea) AND ([*List - Beds with
GMA].BedCode = [*Notes by 2-Bed].Bed)
WHERE ((([*Notes by 2-Bed].Notes) Is Not Null)) OR ((([*Notes by
2-Bed].Quota) Is Not Null));

And, back to the issue with the "big" report: each small report I've built
from a different source works on-screen and in print. When I place three of
them as subreports in the main report, they work on-screen but not in print.
The error message is: "This expression is typed incorrectly, or it is too
complex to be evaluated". I wonder if having two filters in the query (notes
is not null, quota is not null) is confusing the print job.

You stated:
"Each of the subreports come from their own tables/queries where I have
sorted the info I'm looking for"

I don't know if you actually mean "sorted" since sorting is just placing in
a particular order. All sorting should be performed in the report sorting and
grouping dialog, not the query. If you really meant "filtered" then you need
to explain how the filtering is performed.

Also, your original statement was "shows only subreport headers when saved
to pdf or printed
in hard-copy". What do you mean by "subreport headers"? Do you mean the
report header sections of the subreports?

--
Duane Hookom
Microsoft Access MVP

Thanks Duane - delving into a world I'm not totally familiar with now. In
summary, main report has three subreports. Main report fields come from one
table. Each of the subreports come from their own tables/queries where I
have sorted the info I'm looking for. Here is the sql for the main report.
The sql for the subreports are long - do you really want that??!!

SELECT [*List - GMAs].MgmtRegion, [*List - GMAs].GMA, [*List -
GMAs].GMA_Name, [*List - GMAs].Short_Description, [*List - GMAs].Rotation
FROM [*List - GMAs]
WHERE ((([*List - GMAs].Rotation)=3 Or ([*List - GMAs].Rotation)=4))
ORDER BY [*List - GMAs].GMA;

I'm still hoping you can provide the SQL properties of your report record
sources. Also, it might help if you would provide information on any code the
opens/closes the report or a form related to the report or its record source.
--
Duane Hookom
Microsoft Access MVP


:

Thanks for your help Duane - you must be bored today! All the main reports
I've built are based on (and sorted by) an area description called "GMA" -
this information is in the report "GMA header"; this is my Master. The
subreports contain various notes and numbers relevant to each GMA, but on a
finer detail - smaller chunks of area - but each connected back to the main
GMA. So "GMA" in each Subreport is the Child. My larger list of GMAs is
sorted by four groupings - 1, 2, 3 or 4. So, I built a query to select only
3 or 4, and this provides the info necessary to build the main report "GMA
header". Since everything appears to work on-screen, but not printing to PDF
or printer, our IT person is guessing that I've simply got a page set-up
complication somewhere. However, we're both now getting this messsage: This
expression is typed incorrectly, or it is too complex to be evaluated. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to variables.
(Error 3071). I'm in the midst of going back thru queries that are working
and comparing them to these not working and trying to find any differences.

:

Could you provide some details/sql of your main and subreports. This might
help explain how "I've set one criteria to restrict the amount of data
showing".
--
Duane Hookom
Microsoft Access MVP


:

The subreport is built on a query wherein I've set one criteria to restrict
the amount of data showing. All other tables, queries and subreports are
closed when I'm attempting to run the report. Strangely, I have four other
comparable sized reports in the database that are all working as expected.
One of them contains more subreports than this one, so I really don't think
it can be a capacity issue. I've been thru the page set-up, checked all the
obvious master/child relationships, and it's still not working!

:

Are you getting any criteria from controls on a form? Are you closing the
form with code contained in your report?

--
Duane Hookom
Microsoft Access MVP


:

I have a report with three subreports which works fine on-screen and in
print-preview, but shows only subreport headers when saved to pdf or printed
in hard-copy. Is it possible that the subreports are too complicated for
printing? Thanks much!

 

[JR]

Duane - all of your help is very much appreciated. I finally went back and
(once again!) deleted the whole series of queries and reports, and rebuilt
them based on one that was working. This time it appears to have helped. By
redirecting to the desired data source but using the format of a report
that's functioning, I was able to print the results. One of our earlier
assumptions was that there was a page set-up complication somewhere, and that
appears to have been correct. Thanks again.

Yes, sorry! This is getting complicated! I placed "sorts" in the queries; I
have removed them and just sorted the reports. I also filtered the queries
for the particular records I was looking for in the reports. For example:

SELECT [*List - Beds with GMA].GMA, [*List - Beds with GMA].StatAre, [*List
- Beds with GMA].SubArea, [*List - Beds with GMA].BedCode, [*Notes by
2-Bed].Season, [*Notes by 2-Bed].Notes, [*Notes by 2-Bed].Quota
FROM [*List - Beds with GMA] LEFT JOIN [*Notes by 2-Bed] ON ([*List - Beds
with GMA].StatAre = [*Notes by 2-Bed].Area) AND ([*List - Beds with
GMA].SubArea = [*Notes by 2-Bed].Subarea) AND ([*List - Beds with
GMA].BedCode = [*Notes by 2-Bed].Bed)
WHERE ((([*Notes by 2-Bed].Notes) Is Not Null)) OR ((([*Notes by
2-Bed].Quota) Is Not Null));

And, back to the issue with the "big" report: each small report I've built
from a different source works on-screen and in print. When I place three of
them as subreports in the main report, they work on-screen but not in print.
The error message is: "This expression is typed incorrectly, or it is too
complex to be evaluated". I wonder if having two filters in the query (notes
is not null, quota is not null) is confusing the print job.

You stated:
"Each of the subreports come from their own tables/queries where I have
sorted the info I'm looking for"

I don't know if you actually mean "sorted" since sorting is just placing in
a particular order. All sorting should be performed in the report sorting and
grouping dialog, not the query. If you really meant "filtered" then you need
to explain how the filtering is performed.

Also, your original statement was "shows only subreport headers when saved
to pdf or printed
in hard-copy". What do you mean by "subreport headers"? Do you mean the
report header sections of the subreports?

--
Duane Hookom
Microsoft Access MVP

Thanks Duane - delving into a world I'm not totally familiar with now. In
summary, main report has three subreports. Main report fields come from one
table. Each of the subreports come from their own tables/queries where I
have sorted the info I'm looking for. Here is the sql for the main report.
The sql for the subreports are long - do you really want that??!!

SELECT [*List - GMAs].MgmtRegion, [*List - GMAs].GMA, [*List -
GMAs].GMA_Name, [*List - GMAs].Short_Description, [*List - GMAs].Rotation
FROM [*List - GMAs]
WHERE ((([*List - GMAs].Rotation)=3 Or ([*List - GMAs].Rotation)=4))
ORDER BY [*List - GMAs].GMA;


:

I'm still hoping you can provide the SQL properties of your report record
sources. Also, it might help if you would provide information on any code the
opens/closes the report or a form related to the report or its record source.
--
Duane Hookom
Microsoft Access MVP


:

Thanks for your help Duane - you must be bored today! All the main reports
I've built are based on (and sorted by) an area description called "GMA" -
this information is in the report "GMA header"; this is my Master. The
subreports contain various notes and numbers relevant to each GMA, but on a
finer detail - smaller chunks of area - but each connected back to the main
GMA. So "GMA" in each Subreport is the Child. My larger list of GMAs is
sorted by four groupings - 1, 2, 3 or 4. So, I built a query to select only
3 or 4, and this provides the info necessary to build the main report "GMA
header". Since everything appears to work on-screen, but not printing to PDF
or printer, our IT person is guessing that I've simply got a page set-up
complication somewhere. However, we're both now getting this messsage: This
expression is typed incorrectly, or it is too complex to be evaluated. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to variables.
(Error 3071). I'm in the midst of going back thru queries that are working
and comparing them to these not working and trying to find any differences.

:

Could you provide some details/sql of your main and subreports. This might
help explain how "I've set one criteria to restrict the amount of data
showing".
--
Duane Hookom
Microsoft Access MVP


:

The subreport is built on a query wherein I've set one criteria to restrict
the amount of data showing. All other tables, queries and subreports are
closed when I'm attempting to run the report. Strangely, I have four other
comparable sized reports in the database that are all working as expected.
One of them contains more subreports than this one, so I really don't think
it can be a capacity issue. I've been thru the page set-up, checked all the
obvious master/child relationships, and it's still not working!

:

Are you getting any criteria from controls on a form? Are you closing the
form with code contained in your report?

--
Duane Hookom
Microsoft Access MVP


:

I have a report with three subreports which works fine on-screen and in
print-preview, but shows only subreport headers when saved to pdf or printed
in hard-copy. Is it possible that the subreports are too complicated for
printing? Thanks much!