Steema Central

Hi,

I'm using TeeChart for printing a Bubble Chart in a MS Access Form and Report. I'm using an ADO-Recordset, for example:

ado_conn.Open ...
rs.Open TabName, ado_conn ...
teeChart.Series(0).DataSource = rs
teeChart.Series(0).YValues.ValueSource = "Y"
teeChart.Series(0).XValues.ValueSource = "X"
teeChart.Series(0).LabelsSource = "Bezeichnung"
...
rs.Close
ado_conn.Close

This works fine in my form, but not in the report (Since I use MS Access 2003)
In my report I cannot open an ADO-Connection.

The table contains up to 600 records, which makes it not very comfortable to iterate the whole table and add each record manually by using the "addXY"-method.

Maybe you know a better way to get the data to the TeeChart in the Report.

Thanks,
Chris

Hi Chris,

how about exporting the Chart to an image, and then use this image in the Report ?