Link to home
Start Free TrialLog in
Avatar of mallow
mallow

asked on

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?  

ASKER CERTIFIED SOLUTION
Avatar of biko071598
biko071598

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of biko071598
biko071598

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.

 
Avatar of mallow

ASKER

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?
yes....modify the sp to return the parms in the resultset...then use them as datafields....