Reference Main Report Crosstab Query from Subreport

[blinton25]

Hi,

I have the following crosstab query which I use to
generate my Mainreport:

SELECT regionorder, Regions3, 1 As Quarter, January as
A, February as B, March as C, RegionTotal FROM
RegionofResidenceCrosstab
UNION ALL
SELECT regionorder, Regions3, 2 As Quarter, April, May,
June,RegionTotal FROM RegionofResidenceCrosstab

where A, B and C are displayed on the mainreport.

I wish to display regiontotal (the total of A, B and C)
on a SubReport, but to do this currently I have to run
the query again in my subreport.

Is there a way to reference the Crosstab query used in
the main report from the subreport, so the query is run
only once?