CR 8.5 to CRXI upgrade throwing formula errors.
We have several reports developed in CR8.5. We export these reports to disk as excel, PDF etc files depending upon user preference. This original application is a VB6.0 application and it uses CR COM APIs to generate the reports.
Recently we have upgraded this report generating application to VB.Net. As part of that we removed COM APIs and instead used .NET CR APIs. We also upgraded CR from 8.5 to XI.
After this we started encountering various issues. The one we are still stuck with is a formula error. The RPT file has not changed so as the database schema. Everything is as is.
When we use ReportDocument.Export method, it throws an exception saying, a string is required here. It points to a formula where, a database column of type Varchar is used.
We opened this report in the CRXI designer and tried to preview it there. The problem persisted there as well. One thing we noticed, when we preview in the designer, we get a message saying underlying database stored procedure has changed and it needs to be fixed. When OK is clicked here, it displays the field mapping dialog box. This dialog box has fields on the reports and from the stored procedure. The strange behavior here is, all the fields which are on the report (not the ones used in formulas and not displayed) are mapped only. Once this mapping dialog box is closed, the error is thrown. Also at this point if you notice, the database fields, they donu2019t have correct datatype. The field that is throwing error changes into a number field from a string (varchar) field.
This is the problem we are stuck with for last few days and not able to get around with.
We are using ODBC to connect to our SQL Server 2000 database.
Has anybody encountered any problem similar to this.
Ludek Uher replied
Now, having said the above, I'd highly recommend that you upgrade to CR XI R2. You say up have CR XI, however I am not sure if that is CR XI R1 (11.0) or CR XI R2 (11.5). If you do not have CR XI R2, follow these steps;
1) Back up your keycode as you will need it to install CR XI R2
2) Download CR XI R2;
3) Uninstall CR XI R1
4) Install CR XI R2
5) Get CR XI R2 to SP 6. See [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/CrystalReports2008-VersionandDownloadinformationforSPsand+FPs] wiki
6) Open your reports in CR XI R2 designer. If they do not work in the designer, post your query to the Design forum
7) Once the reports work in the designer, open your .NET project. It should automatically ask if you want to upgrade the references.
Follow us on Twitter http://twitter.com/SAPCRNetSup
Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]