467,882 Members | 1,159 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

Changing query for MS Graph

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!


Nov 13 '05 #1
  • viewed: 955

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by z0ink | last post: by
reply views Thread by savas_karaduman | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.