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",...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-through query for sub report 1
sub report and non-fixed column cross tab quesry 10
Sub report based on Crosstab query 4
Crosstab in a Subreport running slow...not due to dynamic headings 2
Totalling SubReports - have tried and tried 7
Subreport error 'can't use crosstab qry' 5
Queries in Subforms 2
Generating a subreport for a pass-through query 1

Back
Top