N
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
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