subReport Prob

[KRISH]

hi,
I have designed a two subreports using crosstab query as
record source. the crosstab query is based on a union
query. Problem is if i open subreports its opening fine.
when i open main report where both or any one of the
subreports present is giving and error, below:

You can't use a pass-through query or anon-fixed column
crosstab query as a record source for a subform or
subreport.
Before you bind tha subform or subreport to a crosstab
query, set the query's column Heading property.

help me what's wrong with me. and how to solve the prob.

thanks.
krish

 

[Duane Hookom]

Go back to the design of your crosstab and do exactly as the error message
suggests "set the query's column Heading property".

 

[KRISH]

how to set the property please tell me I am not getting.

 

[Duane Hookom]

View the crosstab report's property dialog to find the "column headings"
property. Enter your possible column headings such as
Column Headings: "Jan", "Feb", "Mar",...
or
Column Headings: "Bob","Bill","Mary","Joyce",...