PC Review


Reply
Thread Tools Rate Thread

Bound Chart in Report Issues - Access 2007

 
 
Andre
Guest
Posts: n/a
 
      23rd May 2010
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

 
Reply With Quote
 
 
 
 
Mark Andrews
Guest
Posts: n/a
 
      23rd May 2010
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" <(E-Mail Removed)> wrote in message
news:Oq1jtUh#(E-Mail Removed)...
> 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


 
Reply With Quote
 
Andre
Guest
Posts: n/a
 
      24th May 2010
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" <mandrews___NOSPAM___@rptsoftware.com> wrote in message
news:ujYw$Eq#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:Oq1jtUh#(E-Mail Removed)...
>> 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

>

 
Reply With Quote
 
Mark Andrews
Guest
Posts: n/a
 
      24th May 2010
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" <(E-Mail Removed)> wrote in message
news:uc7k20t#(E-Mail Removed)...
> 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" <mandrews___NOSPAM___@rptsoftware.com> wrote in message
> news:ujYw$Eq#(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:Oq1jtUh#(E-Mail Removed)...
>>> 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

>>

 
Reply With Quote
 
Andre
Guest
Posts: n/a
 
      25th May 2010
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 Removed)
Phone: xxx-xxx-xxxx
Hours: 7am - 4pm Eastern


"Mark Andrews" <mandrews___NOSPAM___@rptsoftware.com> wrote in message
news:uGVUyTz#(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:uc7k20t#(E-Mail Removed)...
>> 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" <mandrews___NOSPAM___@rptsoftware.com> wrote in message
>> news:ujYw$Eq#(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:Oq1jtUh#(E-Mail Removed)...
>>>> 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
>>>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 Report Format issues Ed Microsoft Access Reports 1 12th Dec 2008 09:13 PM
Radar chart in Access 2007 report Martin Microsoft Access Reports 0 29th Jan 2008 09:41 AM
Re: Record-Bound Pie Chart in an Access Report Duane Hookom Microsoft Access Reports 0 10th May 2005 08:30 PM
Re: Record-Bound Pie Chart in an Access Report Duane Hookom Microsoft Access Reports 0 9th May 2005 10:15 PM
Re: Record-Bound Pie Chart in an Access Report Duane Hookom Microsoft Access Reports 0 6th May 2005 03:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:40 AM.