Ques on using sp's for reports

[batteam]

I am wondering if there is a way to send over a criteria parameter to a sp that is a record source for a report. I am having no trouble defining a parameter in the rpt's input property box (sent from a form, for example), but I still want to send another parameter from a form to further define what the sp shows on the report. If I list something in the sp like "@myparameter int" and use it in my 'where' clause in the sp, how/where would I send "@myparameter" over from my form when my report is run? Again, this would be a different parameter that what is defined in the report's input property box. Thanks for any assistance you can offer.

 

[batteam]

I have solved my problem. The report's input parameter box does allow for defining and sending over more than one parameter to the report's record source sp. Simply separate the two parameter stmts in the input property box with a comma.