Dynamic Reports

[Fornatian]

I am building a stacked barchart in an access report using source data from a table-it will be a soil profile when complete.

Access does not have a stacked bar chart option, so I am having to resort to drawing boxes using the 'line' method and cycling through each record in DAO changing the height, top-left starting position and colour in code

Does anyone have a better idea of how I can do this as I am having severe difficulty getting the boxes to display in the right place?

 

[accesswatch]

You should use Microsoft GRAPH 97 in your Access Database report. Graph 97 is not installed as part of the standard Install therefore you will need to do a custom install. This should be much easier than hard coding your own Graph generator.
Look up Graphs in your help file

Alternatively you could embed Excel sheet into your report, This has quite heavy resource overheads though but does have some powerful charting features.
Hope this helps
Trevor from www.accesswatch.co.uk