468,309 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,309 developers. It's quick & easy.

subReport on crosstab query giving error

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

Similar topics

2 posts views Thread by James Neumann | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by Sherman H. | last post: by
2 posts views Thread by deejayquai | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.