Report based on Stored Procedure

  • Thread starter Thread starter Newbie
  • Start date Start date
N

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
 
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
 
for SQL it says to use stored procedures if there are input parameters and
this is quite a complex query.

Any more ideas anyone?
 
Back
Top