[AccessD] Access Charts (Graphing) and resolution issue

Lavsa, Rich Rich_Lavsa at pghcorning.com
Tue Nov 30 12:19:04 CST 2004


That sounds exactly like what is happening to me.  

I suppose there is no way to "trick" the application that it is actually
set at 1024x768 at report generation time is there?

Rich


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Tuesday, November 30, 2004 12:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access Charts (Graphing) and resolution issue



Here is one explanation, maybe hunt around their site for further info.
They do a lot of Access printer work.

There is a bit of a bug in Graph, that runs something like this:

If you create a graph in a report where your screen resolution is say
1024x768  and then move that report with a graph in it to a machine
running 800x600, the internal OLE object for the Graph, doesn't resize
and your graph appears to run out side of the OLE control.  I'm assuming
that's what you are seeing when trying to play with the zoom etc.

The only way to work around this is to design your graphs at a modest
resolution and make sure that the internal chart area inside the graph
object itself (not the ole control on the page, but the chart area) has
sufficient room around it so that if the graph container "shrinks" on
page resolution, that its still fully visible.

This impacts printing (i.e. the visible resolution of the screen), due
to WYSIWYG (haven't heard that term in a while) interplay between the
screen resolutions and printer output in drawing.
-- 
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Lavsa, Rich wrote:

>I had checked that before and all are set to (small fonts) Normal Size 
>or 96 DPI depending on the Windows version XP or 2000.  Either way all 
>are set to 96DPI.
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
>Sent: Tuesday, November 30, 2004 10:51 AM
>To: 'Access Developers discussion and problem solving'
>Subject: RE: [AccessD] Access Charts (Graphing) and resolution issue
>
>
>Rich,
>
>A possibility is that the DPI setting on your screen resolution might 
>be different between PC's.  Go to Settings, push Advanced, and see what

>your setting is and your customer's setting.  Changing DPI will affect 
>the resolution of the entire screen.
>
>Dan Waters
>ProMation Systems
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lavsa, Rich
>Sent: Tuesday, November 30, 2004 9:10 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Access Charts (Graphing) and resolution issue
>
>Hello all,
>
>I have an issue.  I spent hours getting my graphs to work properly on 
>these reports.  I seem to have hit yet another snag with the chart 
>object.  I have my resolution set to 1024 x 768 and my users are 
>usually on 800 x 600.  I take into account when developing to make sure

>the screens fit on a 800 x 600 screen.  I didn't do testing on my 
>graphs using a standard users computer because I didn't even think this

>would be an issue.  What is happening is that the graphs are getting 
>chopped off at the Right hand side on a users machine where they are 
>not on my machine.
>
>Just to test my theory that it had to be the resolution I reduced mine,

>and it happened to me as well.  I am certain it has to do with the 
>resolution set on each machine.
>
>Has anyone ever encountered this, or have any idea on how to overcome 
>it.  The graphs are somewhat complex in the fashion that I have to 
>populate temp tables because the aggregation will not happen all at 
>once in a query, and most of the graphs are trend style over a month or

>even yearly so they are usually wide.
>
>Thanks in advance
>Rich
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list