Hi All,
I have a subreport based on a two-value crosstab query that is giving me grief. The crosstab query is based on dhookom's faq701-4524. I have modified it and it was working fine. My crosstab query pulls its info from two other "feeder" queries. Both the other queries contain date criteria as part of their data selection. I am using the "DatePart" function to base the feeder queries on a specified quarter.
When I had the quarter criteria hard coded in the two feeder queries, the whole process worked fine. I have now developed a user form which allows the user to choose a quarter and have adjusted the feeder queries accordingly.
Each feeder query works fine by itself. The crosstab query works fine. When I view the subreport by itself, it works fine. When I run the full report I get the following error:
"You can't use a pass-through 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 ColumnHeadings property."
and the subreport is not visible in the full report.
If memory serves me correctly, I was getting a different error message last week when I worked on it. It was saying that the equation was too complex.
Can anyone give me some hints/help to try and figure this out? I'm soon due to use this to generate another report.
Thanks in advance,
TechieJr.
I have a subreport based on a two-value crosstab query that is giving me grief. The crosstab query is based on dhookom's faq701-4524. I have modified it and it was working fine. My crosstab query pulls its info from two other "feeder" queries. Both the other queries contain date criteria as part of their data selection. I am using the "DatePart" function to base the feeder queries on a specified quarter.
When I had the quarter criteria hard coded in the two feeder queries, the whole process worked fine. I have now developed a user form which allows the user to choose a quarter and have adjusted the feeder queries accordingly.
Each feeder query works fine by itself. The crosstab query works fine. When I view the subreport by itself, it works fine. When I run the full report I get the following error:
"You can't use a pass-through 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 ColumnHeadings property."
and the subreport is not visible in the full report.
If memory serves me correctly, I was getting a different error message last week when I worked on it. It was saying that the equation was too complex.
Can anyone give me some hints/help to try and figure this out? I'm soon due to use this to generate another report.
Thanks in advance,
TechieJr.