Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

When I modified SP, How to verify a Crystal report to reference SP??

Status
Not open for further replies.

DeanLai

MIS
Jun 14, 2010
5
TW
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.
 


Sorry, I had solved this question...
Because my Subreport which is link to mainreport,
So before verify subreport's DB, I must delete all link first, and after verify, add link parameter to mainreport, then save. The error don't happen...LOL

So I don't know is this the way to solve this question, but seem Ok to me...Sleepy

Thanks again your time...
Have a nice day
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top