Dyanamic reports using a cross tab query data source

[Guest]

I would like to create a report dynamically setting and changing the column
headings and controlsource in the detail section.

I can set the column headings and controlsource of the detail in the
report_open event. However, each time a field of the recordsouce changes,
what I'm calling area, then I want a page break with new column headings and
a new controlsource for my detail fields.

I get an error message when I try to change the controlsource in the area
group heading. Is there a work around for this problem? It appears the
control source may only be changed on report_open. Perhaps I could set up a
subreport within the area group, and set the column headings and
controlsource in the report_open of the subreport?

Any ideas will be appreciated. Thanks.

 

[Duane Hookom]

The Crosstab.Mdb in the download at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4 has a sample that does
this. It requires much less code than most other solutions.