Access Report 'Graphs' - Rendering Issues at time of load

P

phxpoolplayer

I am running a function/report that completes the following:

1. Modifies a temp table based on user selection (two variables - Easy)
2. Modifies the temp table with summary line at end of table (summarizing
table data - Totals for Graphs)
3. Render a report based on that table
4. Render 6 graphs to show on the report

All should be good at this point. Table is modified/updated with correct
detail information and summary line. Report opens and queries the table
correctly (always).

Issue: Each Graph has a select statement based on each requirment (two items
only) and the report runs 95% of the time correctly (correctly meaning all
six graphs rendor). However, the other 5%, one of the Graphs will NOT render
and reverts back to what ever the data was on the graph at time of
development (which is blank now).

This occurs mostly after i run two or three reports (and then the fourth time
one of the graphs will faulter). But, it happens more often when my users try
and run it. I believe it is a timing issue based on memory usage but am not
sure.

Does anyone have any knowledge on this type of issue...????? Help!!!

Phx
 
P

phxpoolplayer via AccessMonster.com

Duane said:
ACG Soft has some report tips on graphs that might fix your issue

http://www.groupacg.com/
I am running a function/report that completes the following:
[quoted text clipped - 22 lines]
Thanks Duane, unfortunately I do not see a solution to my issue on this site.
My issue is not with printing, it is with rendering (timing of) graphs
utilizing a dataset. I don't believe an add-in will help this issue.

Thanks for your help.

Phx
 
D

Duane Hookom

I was expecting you to find the free tip/code that resolves some timing
issues by requerying the chart object.

From the ACG Soft site:
==========================
Add the following Visual Basic code to the On Print event of the section of
the report that contains the Graph object.

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
==========================
--
Duane Hookom
Microsoft Access MVP


phxpoolplayer via AccessMonster.com said:
Duane said:
ACG Soft has some report tips on graphs that might fix your issue

http://www.groupacg.com/
I am running a function/report that completes the following:
[quoted text clipped - 22 lines]
Thanks Duane, unfortunately I do not see a solution to my issue on this site.
My issue is not with printing, it is with rendering (timing of) graphs
utilizing a dataset. I don't believe an add-in will help this issue.

Thanks for your help.

Phx
 
P

phxpoolplayer via AccessMonster.com

Duane, This worked like a charm. Thank you so much for solving this
'maddening' issue for me.

Phx

Duane said:
I was expecting you to find the free tip/code that resolves some timing
issues by requerying the chart object.

From the ACG Soft site:
==========================
Add the following Visual Basic code to the On Print event of the section of
the report that contains the Graph object.

On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing
==========================[quoted text clipped - 12 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top