By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Changing query for MS Graph

P: n/a
TD
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

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.