linking subreports to the main report

[tialongz]

I have generated multiple crosstabs from the same main table. (I have multiple value fields) Then each of these crosstabs is created into a report. I am trying to combine all these reports into 1 main report. I used one of these crosstabs - report as the base, then started dragging in all of the reports into the detail section of the report. I then linked all the reports (subreports) by the CustomerID.
Then I ran the report, but i got the message:

"You can?t use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport. Before you bind the subform or subreport to a crosstab query, set the query?s ColumnHeadings property. "

Anyone know how to solve this problem?
Thanks in advance.

[OBP]

Can you "set" the Query's Headings, i.e. are they Months of the Year or Years?
To set them you use the Queries "Properties".

[tialongz]

Can you "set" the Query's Headings, i.e. are they Months of the Year or Years?
To set them you use the Queries "Properties".

Are you talking about the column field? It is in years.