Crystal Reports on the web

Looking at the huge number of links, my code snippets and samples that I've accumulated during my journey with Crystal Reports and Report Server (RAS), I've realized that something should be done with all that. So, for all who are struggling with similar problems I've faced while pursuing that elusive goal of putting Crystal Reports on the web, I will put as much information here as I can ...

Thursday, March 02, 2006

Database schema change

Crystal is usually good with handling database schema changes, but it has limitations. If you change underlaying schema substantially, for instance, remove parameters, or change cursor, you can get that awfull 'Illegal operation' error, while Crystal Reports shuts itself down.
To avoid that, if you know that database changed substantially, don't even attempt to do "Verify database", but go and update database location to that same table/stored procedure/package that you had before. Crystal will rewrite new schema without attempting to verify old one, and then you can proceed to reconcile your report with new changes.