Hi all... i have a problem i can't solve....
i have a very very simple stored in my sql server db
CREATE PROCEDURE [dbo].[try]
@Par as int
SET NOCOUNT ON;
SELECT Field1 FROM Table1 WHERE Option=@Par
then, i create a simple report. i choose odbc connection and the dsn name. then i added the SP and crystal ask me for the parameter value. then i added the field to the report, print it and save it... and this works fine.
now... i need to print "Field2"... so a alter the procedure
SELECT Field1, Field2 FROM Table1 WHERE Option=@Par
open the report and press "verify database"... crystal ask me for parameters and then i have the error
"the table doesn't exists in the database. do you want to remove it?"
i presso no and i have the message "database is ok" and the report works, but without field2..
i also tried to not modify the SP with field2, so just create the report and press "verify database", with no modifications at all... same error!
obviously this is an example i made to verify if my real report (much more complicated) as a problem, but is not.
with old crystal report 8 no problems! but if i use the report made with cr8 with the 2008 runtime (vb .net 2008 application) the report doesn't work
what shall i do? i can't have a report that i can't modify in the future!!