Using TeeChart in a MS Access Report

[Chris L]

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

[Pep]

Hi Chris,

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