SQL Stored Procedures and passing text related to a variable

[trueharted]

I'm not sure if this is a Crystal Reports issue or if I just need to know how to pass something from the Stored Procedure side.

Is it possible to pass text related to a variable in a stored procedure to the resulting parameter's "prompting text" in a Crystal report? The parameter in the Crystal report is grayed out except for the prompting text field (which is blank), but when you enter something in it, save, close then reopen the report it doesn't keep it.

I have a stored procedure that passes two variables @from_date and @days to my Crystal report (as parameter fields, populating the name of the parameter with the name of the variable and the value type, aka data type, with the data type of the variable). The parameters in Crystal {?@from_date} and {?@days} need prompting text but trying to add it in Crystal isn't working.

 

[trueharted]

I found the answer. There is a Crystal Hot Fix for this issue at

http://support.businessobjects.com/downloads/monthly_hot_fixes/crystalreports.asp.