Report based on Stored Procedure

[Newbie]

Hi,
I have an Access Project with a report that is based on a stored procedure
that has parameters.

How do I pass the parameters to the stored procedure?

I can pass the parameters so that I get a recordset but am I right in
thinking that the report cannot be based on a recordset?

Any help greatly appreciated

A

 

[Ketaki]

base your report on a query and in the query accept
parameters as [enter name etc.]. when you base your report
on a query it will automatically run the underlying query
and ask user for parameters if that is what you want.
queries give you a lot more flexibility to design complex
SQL queries.

-Ketaki

 

[Alison]

for SQL it says to use stored procedures if there are input parameters and
this is quite a complex query.

Any more ideas anyone?