subReport Prob

  • Thread starter Thread starter KRISH
  • Start date Start date
K

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
 
Go back to the design of your crosstab and do exactly as the error message
suggests "set the query's column Heading property".
 
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",...
 
Back
Top