Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matkwan
Starting Member
36 Posts |
 Posted - 2002-07-23 : 09:21:07
|
| Hi I have a report form allows user to enter the date range of the report, and a button on the form to generate the report which will show a graph. I got all this to work, however now I want to dynamically construct a SQL on the report form and then pass the SQL to report which will then pass the SQL to the Microsoft Graph, but I dun know how to do it. What code should be behind the generate report button to pass the SQL to the Report and then to the Graph Object ?At the moment, I have this behind the button: DoCmd.OpenReport "rpt_Quote_Activity_Monthly_Graph", acViewPreview And I also have hard coded the SQL to the Row Source of the Graph Object. This is not flexible.ThanksMatthew |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-07-25 : 06:54:51
|
| You might want to try a MS Access forum for best results. This group is pretty much only SQL Server. |
 |
|
|
|
|
|
Microsoft Graph Chart