Skip to Content
0
Former Member
Mar 28, 2011 at 12:33 PM

Reports deployed to 64bit CR4VS2010 show incorrect data

20 Views

Hello,<br />

<br />

I have a similar issue as described in this thread:<br />

Critical - Production Report is wrong. Correct in Visual Studio! <br />

<br />

Weu2019ve got major problem with reports deployed to 64bit machine (Windows Server 2008) where we have IIS7 and 64bit CR4VS2010 redistr installed.<br />

Weu2019ve found at least one report that prints incorrect values when compared to EXACTLY the same report run on 32bit server (for example development machine).<br />

<br />

We have a report template (designed in CRXIR2) that is stored in a database and is retrieved from there when it is needed. Our business logic executes some sql query that is transformed into a DataTable, which is then passed to CrystalDecisions.CrystalReports.Engine.ReportDocumentu2019s SetDataSource method:<br />

report.SetDataSource(dataTable); <br />

<br />

We show a report using default CrystalReportViewer ReportSource property:<br />

crv.ReportSource = report; <br />

<br />

The report involves heavy grouping, suppressing and conditional summarizing.<br />

Weu2019ve compared three outputs from the report on:<br />

- 32bit server with CRXIR2 runtime installed<br />

- 32bit server with CR4VS2010 runtime installed<br />

- 64bit server with CR4VS2010 SP1 runtime installed<br />

<br />

First two machines show the same correct data. The last one shows completely messed up data, that is, information from different groups are mixed up, doubled, tripled, sorted in different way that it is designed in the report (itu2019s hard to explain whatu2019s wrong without seeing the report).<br />

<br />

To be sure that we feed the report with the same data I dump and compare dataTable using WriteXml method. <br />

<br />

Exactly the same report has been used for several years on 32bit machine without any issue so I donu2019t believe there is any mistake on our side.<br />

<br />

I can provide the report template, xml datatable and report with saved data executed on 32 and 64bit machine.<br />

<br />

Could you please help?<br />

<br />

Kind Regards<br />