Pass Through Abfrage in Subreport

[ug]

Hello Access Freaks,

From a "pure" ACCESS DB with tables contained directly in
the database I have changed to linked tables contained in
an SQL-database.

The problem is:

A report that calls two subreports - each of these two
subreports is based on a pass-through query (this
implicates an enormous runtime benefit; each of these
subreports works properly singele-handled)
BUT: The complete report ends with the ACCESS information:

"You cant't use a pass-through query or a non-fixed-column
crosstab query as a record source for a subform or
subreport".

Which solution can I use to get the complete report with
the runtime benefit?
Thanks for your welcomed help!
ug

 

[SA]

UG:

This issue occurs when you have link master / link child fields set, because
the report (Access) can't read field / column headings for the pass-through
when the report is run. About the only way I can think of to do this is to
create a new Access query based on your pass through and turn it into a make
table or append query and dump the passthrough results to the local Access
db. Then base your sub reports on a local view from that temp table data.