Parameter Values from Stored Procedure


hi there, i am using crystal report 5.0, and i have a stored procedure from informix,
that asks for two parameters, when i run my report can i get the value of the paramaters
that i asked from the stored procedure? how can i do this?  

mallowAsked:
Who is Participating?
 
biko071598Connect With a Mentor Commented:
I am assuming that you are using the control and not the crw-api.

Use the

Report.StoredProcParam(Parameter Array Index%)[= newParameter$]
for each parm.

Note that the parms are in the same order as listed in your report.

Hope that helps

0
 
biko071598Commented:
OOOPS...REREAD YOUR QUESTION.  If you're trying to get the result of a stored proc via parms...don't.  Always return data from the stored proc's resultset...i.e. have the sp return data in a table like fashion.

 
0
 
mallowAuthor Commented:
actually, i am using crystal report 5.0 the application, and i need the paremeters to display only on my reports, because my parameters are actually start date and end date, i only need to display these on my reports, you know how?
0
 
biko071598Commented:
yes....modify the sp to return the parms in the resultset...then use them as datafields....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.