Simple Bar Chart Per Line of Report

[naigy via AccessMonster.com]

Hi I have a report with multiple sub reports

In all of these sub reports I have in the device footer section the
devicetype and a qty and also a time (the detail section which falls just
above this lists all units of a particular devicetype but is set to hidden as
it is not relevant for this report). I currently have this working fine and
providing a subtotal in the report footer at the bottom (total qty & total
time).

Now what I need to do is provide two thin line charts, bar charts or similar
next to each of these in the device footer section. So I will have one chart
for qty and one for time for each devicetype. For each of these charts I was
planning on having a scale of 1 -100% and calculating a percentage of each
devicetypes respective qty (in comparison to total qty) and likewise for time.
I think I should be right calculating the percentages required but I do not
know how to go about setting up a bar chart or similar that would work in
this particular situation.

Anyone have any idea where I should start with this. Many Thanks

 

[naigy via AccessMonster.com]

I finally managed to find a guide on Microsoft website (
http://support.microsoft.com/?kbid=304583) that is titled

"ACC2002: How to Graphically Display Percent of Total on a Report"

This according to the article does exactly what I want.

However when I get to the vba code which it says to put in the on format
event it doesn't accept the width command

Me!Box19.Width = .... ... ... ...
..width is not one of the options which come up in the drop down list (it does
appear when trying to do this in a form but not in a report as it is titled
in the ms guide). I am using access 2003 in a 2000 - 2002 database.

Anyone know of another way to call the width function of an object (rectangle)
in a report.

 

[naigy via AccessMonster.com]

ALL Sorted. I assumed because .width was not listed as an option that it
would not work.