Trouble using data from stored procedure for report!

[Alain Guillemin]

Hi.

I'm having some trouble selecting data for my reports!

When I create a stored procedure from a view which retrieves all data in the
view then I'm able to create a new report with the wizard. I get all data in
the preview and everything seem to work perfectly.
As soon as I try to filter out some of the data in the view by adding a
WHERE-clause in my stored procedure then it goes very wrong! When I execute
the stored procedure my data is there correctly, but when I try to create a
new report based on that stored procedure with the new report wizard, then I
get nothing! Not even a blank report! Same thing if I use a parameter in my
stored procedure!

So as long as all the data is used from the view everything works fine.
Filtering out the wanted data with a stored procedure doesn't work at all!

I need to create a view first because all of the wanted data is stored in
different places and a lot of the data needs to be summarized. Then I need
the stored procedure to be able to use a parameter to select on the wanted
date.

What am I doing wrong? Please help me!

Thanks.

 

[Sylvain Lafontaine]

I would suppose that the way you are using for passing the parameter value
from Access to the stored procedure might be wrong. However, you don't give
a word about the method you are using to pass this value to the SP; so it's
hard to tell you what's going wrong here.