Error while previewing the report.

[former_member739021]

We are getting error in preview and error shows that error in formula but the rpt file has only paramter but no formula.

Could you please let me know why this error

[former_member11696 · Accepted solution]

Did you follow my instructions above and run the report in CR 2020?

[former_member11696]

Hi Mahesh,

Thanks for the report...

So it created in CR 10.2 and connecting using the ADO .NET (XML) driver.

That driver has been update a lot since 10.2, notice in the Report Designer there is no Database Name, DSN, OLE DB server name etc. so the update routine doesn't know what to do with the connection property bag.

And it can't figure out how to interpet that formula fields table.field name. Not sure why it's only that one but likely got to a limit and then reported that formula.

So to fix it I suggest opening the report in a current version of CR Designer, go here and get CR 2016, don't use CR 2020 it's 64 bit: https://www.sap.com/products/crystal-reports.html

Open the report and set the connection to ADO.NET (XML), or you can do it in Visual Studio, and verify the report.

Save it and see if that resolves the issue.

Don

[former_member739021]

Hi don.williams , We are upgrading CR 11.5 to 13.0 version and will be using CR2020.we tried running the report in CR 13version and got this error. So could you please suggest possible way to run this report?

Thanks and Regards,

Mahesh R

[former_member11696]

You have to find that formula and delete it or fix it.

If you zip the report file and then rename it to *.txt you will be able to attach it to the post. I'll open it in my test app and see what the issue is if the SDK can find it.

Don

[former_member739021]

mbcae1d-8180-8268-99320f64-7a01-444d-8261-732467ec.txt

I have attached the txt file . please have a look.

[former_member11696]

It could be a formatting formula in a section.

And verify it is the same report being opened in your app as in CRD.

[former_member739021]

@Don Williams I have verified it is the same report and it is opened in CRD. and i cannot preview report in CRD.