Creating multiple reports dynamically using a cross tab query

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

Guest

I would like to create a report that dynamically creates the column heading
and sets the controlsource of detail fields. This works fine if you use the
report_open event to set these values.

However, I would like to change the column headings and controlsource on a
break in a field I'm calling area (which will cause a page break). However,
if I try to make the change using the format event of the area group I get an
error that controlsource cannot be set. It appears controlsource may only be
set in the report_open event.

Is there a workaround for this problem? I've not worked with subreports
before, but perhaps I could use subreports to allow me to set the
controlsource multiple times within the same report. However, I also want to
be able to change the report title (or perhaps move the report title to the
page heading section), from within the subreport. Is any of this possible?

I will appreciate any help you can provide. Thanks.
 
You may ignore this post. It is a duplicate of "Dynamic reports using a
cross tab query data source. I resubmitted the post because the forum
software told me it failed to create the post. As I saw after I created a
new post that it lied, it did create the post.
 
Back
Top