Dyanamic reports using a cross tab query data source

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top