Report from Stored Proc w/param

  • Thread starter Thread starter Charlie
  • Start date Start date
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
 
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) :-)
 
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 :-)
 
Back
Top