Report from Stored Proc w/param

C

Charlie

I am so thoroughly ocnfused with this whole process, hopefully someone can
help me get this right.

I have a stored procedure that has one parameter, @BeginDate, am trying to
run a report in an Access 2003 ADP. The user is required to input the
Beginning Date they choose. I set the reports record source to the stored
procedure and set the "Input Parameters" to "Beginning Date?" (found in the
properties of the report). I have used this exact same method in another
report (in another adp) and it works perfectly, however with this one I am
getting a "Provider command for child rowset does not produce a rowset".

The stored procedure runs perfectly when run from query analizer, so am
positive that there isn't an issue with the sp.

Any thoughts on why this works one time and not another? Or how to get it
to work, as I am past a deadline at this point and having major stress.

Thank you so much in advance
George
 
C

Charlie

Bless you! I can't believe I have looked at this thing a million times and
didn't catch that. THANK YOU SO MUCH (having much less stress now) :)
 
C

Charlie

Bless You!! I can't believe I have looked at this stored procedure a million
times and totally missed that. arrrgh.

Thank you very much for the second set of eyes :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
adp report does not recognize fields from stored procedure 3
'The stored procedure executed successfully but did not return any records' 4
Stored Proc with param used for combo box 6
ADP report based on stored procedure. 10
Accessing Stored Procedure via VBA 5
Trouble using data from stored procedure for report! 1
ADP and Subreports 2

Top