Report Control Source as Stored Procedure

[Duncan Stott]

I am developing an Access2000 project. I have Reports that
are bound to Stored procedures and that works OK. I now
want to pass input parameters from a form to a report
based on a Stored Procedure. It seems that the input
paramters property is designed to do the job and the help
notes indicate how to set this proporty up. The problem is
that I cant get it to work. Confusingly the help notes
include the following:

"The stored procedure should be executed using a command
string containing the {call } syntax with one ? marker for
each non-default parameter in the InputParameter list"

This I dont understand.

Thanks in advance for any help here

 

[SA]

Duncan:

Open the Northwind adp sample database and look at the Sales by Year sample
report. You'll see there how the input parameters works with a form based
criteria situation.