Hello,
recently, I had to Add a Input parameter into Store Procedure
like
CREATE PROCEDURE dbo.test
@flag varchar(4) = '',
@user varchar(8) = '',
@cmpy varchar(4) = '',
@func varchar(1) = '' --This is new add parameter
as
.......
and there is a Crystal report reference it (my Crystal report used ttx to connect DB).
So when I done SP, then went to verify CR's Database, I pushed "save as...",but it show the message--
?Failed to save document.? and ?Failed to save database information? and ?Query Engine Error. 'The specified object was not saved.'?
When I modified SP, How to verify a Crystal report to reference SP??
ps. There is a subreport in mainreport.
Have any suggestion??
Thanks a lot.
recently, I had to Add a Input parameter into Store Procedure
like
CREATE PROCEDURE dbo.test
@flag varchar(4) = '',
@user varchar(8) = '',
@cmpy varchar(4) = '',
@func varchar(1) = '' --This is new add parameter
as
.......
and there is a Crystal report reference it (my Crystal report used ttx to connect DB).
So when I done SP, then went to verify CR's Database, I pushed "save as...",but it show the message--
?Failed to save document.? and ?Failed to save database information? and ?Query Engine Error. 'The specified object was not saved.'?
When I modified SP, How to verify a Crystal report to reference SP??
ps. There is a subreport in mainreport.
Have any suggestion??
Thanks a lot.