subReport on crosstab query giving error

[krish_4u_only]

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

[Brian]

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