MS Graph 2000 Chart & Stored Procedure w/ parameter

[schlauberger]

I am working with MS Access 2000 (.adp)and I have a report that accepts two prameters from a form via the Input Parameter Property (Report). The report displays data as desired, my problem exists with the Graph that has a seperate Stored Procedure, I cannot pass the parameters. I have tried to set the RowSource property of the graph from the form and during the Open event of the report with no joy. Is there a workaround that I am missing? Or is there a different type of chart supported by MS that will accept a RowSource property on report Open?

Any help would be greatly appreciated, thanks.

[schlauberger]

Could not pass parameter to Stored Procedure to drive the Chart, tried numerous ways. Work around: The form that opens the report On Click Event: Loads an SQL statment with the forms parameters to a string "strSQL."

DoCmd.OpenReport "rptName", acViewDesign
Reports!rptName!oleChart.RowSource = strSQL
DoCmd.Save
DoCmd.OpenReport "rptName", acViewPreview