By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

subReport on crosstab query giving error

P: n/a
Hi,
I have designed a subreport - record source is on crosstab query.
crosstab query is designed on union query. The sub report is working
fine when it is opened individually. but if i place it on another
report it is giving the following error:

You can't us a passthrough 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 column headings property.

please tell me how to solve it.

thanks for any help

krish
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"krish_4u_only" <kr***********@yahoo.com> wrote in message
news:43**************************@posting.google.c om...
Hi,
I have designed a subreport - record source is on crosstab query.
crosstab query is designed on union query. The sub report is working
fine when it is opened individually. but if i place it on another
report it is giving the following error:

You can't us a passthrough 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 column headings property.

please tell me how to solve it.

thanks for any help

krish


You can solve it by setting the query's column headings property. If you
right click the query design window and choose "properties", you will see
the ColumnHeadings property. Enter the headings you want, with each one
enclosed in inverted commas and separated by commas e.g.
"heading1","heading2" etc.

Also, look up "ColumnHeadings" in help!

If your query doesn't have fixed columns, though, you are going to have to
rethink your design. I am sure that if you post again describing what you
are trying to achieve with this report, someone will advise.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.