KeertanaCR
Programmer
Hi,
I have a dynamic Prompt DYP in my report which is pointing to a stored procedure STP, Stored procedure has input parameters SDate and EDate.
So, when refreshing the report, It is asking for the dates twice, first time to get the values for dynamic prompt DYP and second time for the actual report. I guess, asking dates Sdate and EDate to get the DYP values makes sense, but prompting for dates twice is kind of sounds wierd. Is there a way, it can only prompt for the dates only once.
I am using crystal XI and Sql Server 2000
Thank you
I have a dynamic Prompt DYP in my report which is pointing to a stored procedure STP, Stored procedure has input parameters SDate and EDate.
So, when refreshing the report, It is asking for the dates twice, first time to get the values for dynamic prompt DYP and second time for the actual report. I guess, asking dates Sdate and EDate to get the DYP values makes sense, but prompting for dates twice is kind of sounds wierd. Is there a way, it can only prompt for the dates only once.
I am using crystal XI and Sql Server 2000
Thank you