Bound Chart in Report Issues - Access 2007

[Andre]

I have a simple table, containing a count, a status and an agent name.

I created a simple report, with a header by agent name. The idea is that the
report will display as:

Agent Name: Joe Blow
Simple bar chart - Horizontal Access Shows Status - In Progress, Complete,
Not Started
The value will be the count

This will repeat for each agent.

The report has groups, in the group header is the agent name and the chart
is also in the header, the detail section is hidden.

The problem I am having is that when I view the report, the charts flashes
on and off, as if it is a refresh issues. At first I uses a query as the
source. I have since created a temp table as the source.

Currently only a half dozen rows of data.

What am I doing wrong ?

Thanks

Andre

 

[Mark Andrews]

I think that is an issue with Access 2007 and report view. Does the
flashing occur if you open the report in print preview?
Basically only use design and print preview.

There could be another cause that I don't know about but I have seen similar
behavior.

If you are using Vista search the web for vista issues with graphs (can have
some refreshing issues).

HTH,
Mark

 

[Andre]

Thanks Mark. Yes, Print Preview is fine. Layout and Report view is the
problem.

At home I am using Vista 64 bit and at the office XP SP3, does the same
thing on both PC's.

Does anyone know whether MS is working on this ?

I like 2007, but it does seem to be quirky and buggy at times.

Andre

 

[Mark Andrews]

I doubt they are working on this issue. Just make sure you have SP2 and
live with the little bit of buggyness (not sure buggyness is a word).

You could try Access 2010 to see if it suffers from the same issue?

At least report view and layout view are not really needed,
Mark

 

[Andre]

Mark,
Below is the response I received from MS today on this issue. No
resolution yet but something appears to be imminent. I removed the
responder's name as I don't have permission to post this, but here it is.

Looks like we might have a solution by June as the current solution fixed
some problems but introduced some new ones.

Thanks again for you assistance

Andre
========================================
Hi Andre,

How are you? I took a look at your case. It looks like your chart is
flickering continuously when viewing a report in Report View. You are
correct that this is a bug. It has been corrected in the latest cumulative
update (CU) for Access 2007. You can install the latest CU from the
following location:

http://technet.microsoft.com/en-us/office/ee748587.aspx

Unfortunately, since this CU was released, we discovered that it causes a
problem with some wizards as well as the linked table manager. This is
scheduled to be fixed in the next CU which is due out at the end of June.
If you are able to live with the flicker until then, a link to the June 2010
CU will be posted to the above location once it is available. I cannot
guarantee it will be released at the expected time or that it will include
this fix as our development team could run into some unforeseen problems.
However, that is the plan at this time. The June CU is expected to include
the fix for the flickering chart as well.

If you don't wish to wait until the release of the next CU, there is a
workaround for the wizard/linked table manager issue. What you can do is
make a copy of accwiz.dll before you install the CU, and then use it instead
of the updated version of this dll that is installed with the CU.

*Locate accwiz.dll from the following default location: c:\program
files\Microsoft Office\Office12.
*Make a copy of this DLL either in the current folder or paste it elsewhere.
*Install the CU.
*Rename accwiz.dll which has been updated to a later version by the CU.
*Replace it with the copy you made in the first step.

I hope this information helps! I apologize for any inconvenience these bugs
have caused. Please let me know if this information helps you to resolve
the issue or if you need further assistance. Talk to you soon.

Best Regards,

xxxxxxx
Sr Support Engineer - Microsoft Access
Email: (e-mail address removed)
Phone: xxx-xxx-xxxx
Hours: 7am - 4pm Eastern