Crystal 9 and stored procedures with dynamic sql
I use CR9. The report has 8 subreports. The source of each
subreport is a stored procedure in which dynamic SQL statements are
The report does not work in Crystal 9 IDE unless I edit each subreport and run that subreport individually. If I don't do that and directly run the report , the parameters are not passed to the respective stored procedures and the report fails. When called from VB6, it does not work at all.