Prmeds
December 9th, 2004, 05:38 AM
Hello
I am using CR9 ( CRAXDRT9 and CRVIEWER9) + SQL Server 2000.
A report has 8 subreports. The source of these reports are stored procedures.
A problem with this same report is the stored procedures have dynamic sql. To run this report in Crystal 9 IDE, I have to edit each subreport & run it individually first. Otherwise, parameters are not passed to the stored procedures (of the subreports) and the report fails.
Is there a way in which I can have dynamic sql in my stored procedures ?
I have currently removed the dynamic sql, but that does not meet my requitements.
Thanks in advance
I am using CR9 ( CRAXDRT9 and CRVIEWER9) + SQL Server 2000.
A report has 8 subreports. The source of these reports are stored procedures.
A problem with this same report is the stored procedures have dynamic sql. To run this report in Crystal 9 IDE, I have to edit each subreport & run it individually first. Otherwise, parameters are not passed to the stored procedures (of the subreports) and the report fails.
Is there a way in which I can have dynamic sql in my stored procedures ?
I have currently removed the dynamic sql, but that does not meet my requitements.
Thanks in advance