Crosstab query as the control source of a report used as a subreport

[RomeERome]

Hello,

I am trying to use a report created using a crosstab query. The problem that I am having is that it will not let me use that report as a subreport in an existing report.

Access 97 gives me an error message that says that a pass-through or crosstab query can not be used as a control source for a subreport.

Is there a way to to force the report created by a the crosstab query to allow the subreport to exist?

 

[danvlas]

As far as I know, crosstab queries with dynamic column headings cannot be used for subreports.
If you set the Columnheadings property for the crosstab query and use those headings in the subreport, you should be fine.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jdttek]

Dan
I have found the same thing. Setting coumn headings allows use of crosstab as subquery.

I have been able to do this manually. However, is it posible to set / change the column headings through VBA? It appears you can, per Column Propterties Help:
"You can set this property by using the query's property sheet. You can also set it ....... in Visual Basic by using a PIVOT clause in the SQL statement."

Do I need to set the entire record source w/ SQL or is it possible to just change the column headings with PIVOT clause? If so, what is the syntax? Thanks in advance.

JDTTEK