By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Recordset for MS Graph (Chart) through VBA ?

P: n/a
Hello.

I have a MS Access front end/PostgreSQL back-end combination.
There is a report with nested graph (linked master/child fields).
I used saved pass-through queries for both Record Source of the report and
Row Source of the nested graph. It works, but, when I have a lot of data,
the report has several hundreds pages and opening of the report is extremely
slow (cca 20 minutes). It's because for every page it must requery the Row
Source PST query (for the chart) again. I tried to put the select statement
in row source, so that JET queries for graph instead of PostgreSQL, but it
is even slower (cca 50 minutes)...
Now, I would like to avoid requerying for graph for each page. Could I use
the report recordset (that is only once queried) based on the Record Source
saved PST query and just filtrate that recordset and pass it to the graph as
the graph recordset (or Row Source) ? Some RecordsetClone ?
How to pass Recordset to MS Graph by using VBA ? IS there any sample code ?

Thanks in advance,

Zlatko

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
OK, I will answer to myself...
I solved this problem by a local table for graphs. I added code to On Open
event of report that retrieves data by executing PST query on Postgres and
then add such recordset to local JET table. Grapgh Row Source is local
table. Now it is about 20 times faster !

Bye.

"Zlatko Matić" <zl***********@sb.t-com.hr> je napisao u poruci interesnoj
grupi:db**********@ss405.t-com.hr...
Hello.

I have a MS Access front end/PostgreSQL back-end combination.
There is a report with nested graph (linked master/child fields).
I used saved pass-through queries for both Record Source of the report and
Row Source of the nested graph. It works, but, when I have a lot of data,
the report has several hundreds pages and opening of the report is
extremely
slow (cca 20 minutes). It's because for every page it must requery the Row
Source PST query (for the chart) again. I tried to put the select
statement
in row source, so that JET queries for graph instead of PostgreSQL, but it
is even slower (cca 50 minutes)...
Now, I would like to avoid requerying for graph for each page. Could I
use
the report recordset (that is only once queried) based on the Record
Source
saved PST query and just filtrate that recordset and pass it to the graph
as
the graph recordset (or Row Source) ? Some RecordsetClone ?
How to pass Recordset to MS Graph by using VBA ? IS there any sample code
?

Thanks in advance,

Zlatko

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.