Multiple report problem

[Poweruser99]

I am trying to make one report from a collection of 4 reports. The selection criteria of this report comes from a drop down menu in the form. And all 4 reports can also be viewed from the drop down menu. Now the problem is when I want to combine all 4 reports into on.

All 4 reports are from select queries, and all 4 select queries are derived from cross tab queries. When I run the report with all 4 in one, this is the errror I am getting.
___________________________________________________________
"You can't use a pass-through query or non-fixed-column crosstab query
as a record source for a subform or report.

Before you bind the subform or report, set the query's Column Heading
property."
__________________________________________________________

Now I understand that I have to change the columnhead property of the cross tab queries. But these reports are based on select queries, and the select queries are based on cross tab queries.
Does this mean I'll have too edit the column head property of the CROSSTAB query??

Is not there an easier and faster way to do this??

Any help will be of great help.

 

[CosmoKramer]

Try embedding these 4 reports as subreports into an empty main report. They don't have to be linked and each will run with their own record source.

Hoc nomen meum verum non est.

 

[Poweruser99]

Nope I tried that and I get the same exact error message.