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.
Edited by Dean - 14 Jun 2010 at 8:37pm