I have a report that has the MS Graph control on it. I have a query
setup for the control.
I have a form with 6 check boxes where the user can select which fields
they want to appear in the query and thus appear in the report graph.
I want to know the best approach to modify the query on the fly when
the report is run, based on which check boxes are checked.
I've new to using the MS Graph object and have noted that whatever
fields the query returns is what gets graphed in the report.
I think I can use code to "cut and paste" the sql statement the query
represents on the open event of the report and so far this is my only
way to do this unless someone has a better idea. I'm all ears!
Thanks,
TD |