Graphs

[Laura]

I need to create reports with Graphs on them with views that contain
parameters. Can this be done in an ADP?

Laura

 

[Sylvain Lafontaine]

Yes, you can use the same graph control in ADP than for MDB. However, you
don't have access to the wizard in ADP, so I suggest that you first create a
report in MDB and import it into the ADP file to see how it's build. Change
its RowSource and you should be OK.

 

[Laura]

Thank you, that is how I did it. However I would like to pass the
parameters to the view for the graph based on values the user selects/inputs
on a form. I do not see an input parameter property for the graph control
and adding them to the form does not help. I also tried to set the
rowsource of the graph when I open the report and that is not possible either
because the oleGraph object does not have a rowsource property.

Laura

 

[Sylvain Lafontaine]

Hum, try to see if you can get it working using a combination of these two
articles:

http://forums.databasejournal.com/archive/index.php/t-31188.html

http://www.groupacg.com/ARptTip.htm#GRAPHGEN


What do you mean exactly by « Views that contain parameters » ?

 

[Laura]

Sorry meant to say Function not view. The first link may work, I have
used that approach before. My only concern is will that code continue to
work when I convert this to an ADE for the user? I will give it a try and
let you know.

Thanks for the help.

 

[Sylvain Lafontaine]

Why don't you keep going with a MDB file and ODBC linked tables for your
reports instead of going with ADP/ADE?