Crystal reports results different results (13 vs 12)

[Former Member]

Hi,

I using a designer 2008 Crystal reports to create several reports,and i am using the Crystal reports run time on two web servers.

The first web server is a windows windows 2008 R2 using:

• CrystalDecisions.Shared, Version=12.0.2000.0
• CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0
• CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0

* notice that this is a 32 bit although the server itself is a 64 bit

and the other web server is a windows 2012 R2:

• CrystalDecisions.Shared, Version=13.0.2000.0
• CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0

Though the report runs much faster on the second one, it seem that they are not the same

help anyone?

[former_member183750 · Accepted solution]

Though the report runs much faster on the second one, it seem that they are not the same

Well as you say:

The first web server is a windows windows 2008 R2 using:

CrystalDecisions.Shared, Version=12.0.2000.0
CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0

And

the other web server is a windows 2012 R2:

CrystalDecisions.Shared, Version=13.0.2000.0
CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0

So, yes. The re not the same. One is using runtime of version 12.x and the other is using version 13.x.

Thus, what is the question?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

I don't think that it should result a different report as the rpt file is the same and the run time is different.

Is there a way to upload the rpt to test it?

[former_member183750 · Accepted solution]

Different report or different performance?

- Ludek

[Former Member · Accepted solution]

Different report output results, some of the fields are missing, and the most weird is the sorting which has changed totally.

[former_member183750 · Accepted solution]

OK. Just so we are clear, this is what threw me for a loop:

Though the report runs much faster on the second one. it seem that they are not the same

I took that to mean that the performance was different so it looked like different reports. E.g.; there was no mention of fields missing, etc.

Anyhow. Missing fields may result if the data being passed to the report is not what the report is expecting. In that case, the field may simply be discarded by the report engine. E.g.; say the report is expecting an integer, but the is passed a string.

To troubleshoot this, take one of the reports. Open it in the CR designer and enable the options "Verify on 1st refresh" and "Verify stored procedures on 1st refresh". Now run this report from your app. Did that help?

- Ludek