Bound Chart in Report Issues - Access 2007
in [Reports]
|
From: Andre on 22 May 2010 21:13 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
From: Mark Andrews on 23 May 2010 13:56 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" <no(a)email.com> wrote in message news:Oq1jtUh#KHA.5592(a)TK2MSFTNGP02.phx.gbl... > 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
From: Andre on 23 May 2010 21:05 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___(a)rptsoftware.com> wrote in message news:ujYw$Eq#KHA.1892(a)TK2MSFTNGP05.phx.gbl... > 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" <no(a)email.com> wrote in message > news:Oq1jtUh#KHA.5592(a)TK2MSFTNGP02.phx.gbl... >> 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 >
From: Mark Andrews on 24 May 2010 07:33 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" <no(a)email.com> wrote in message news:uc7k20t#KHA.5044(a)TK2MSFTNGP04.phx.gbl... > 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___(a)rptsoftware.com> wrote in message > news:ujYw$Eq#KHA.1892(a)TK2MSFTNGP05.phx.gbl... >> 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" <no(a)email.com> wrote in message >> news:Oq1jtUh#KHA.5592(a)TK2MSFTNGP02.phx.gbl... >>> 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 >>
|
Pages: 1 Prev: Auto-generated Report Next: Updating Form==>Query==>Report |