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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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....