cancel
Showing results for 
Search instead for 
Did you mean: 

Reports deployed to 64bit CR4VS2010 show incorrect data

Former Member
0 Kudos

Hello,<br />

<br />

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

<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 />

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

While waiting for any response Iu2019ve tested and fiddled with the report a bit. Because Iu2019ve realized that the report works OK (at least shows correct data) with small amount of data, I tried to narrow down the point when it gets corrupt.

Here are the results (the report contains five nested groups, the first one is u2018repeat header on every pageu2019 trick group):

- 320-330 records

- 60-70 second level groups

These numbers are not constant and differ depending on data range passed to the report.

First sign of corruption (after the report gets more records) that I see is a distortion in group sorting. What I mean is that my second level group has original order (datatable is sorted like sql query result - 'order by' clause) and in group hierarchy tree I can easily see that they are not arranged in that designed way, for example: 1, 100, 2 instead of 1, 2, 100.

Regards,

Former Member
0 Kudos

Iu2019ve managed to nail down the problem with 64bit runtimes. Itu2019s the original order of groups Iu2019ve mentioned above.

Iu2019m pretty sure there is a bug somewhere in CR that is the cause of the behavior I encounter. All reports that rely on already sorted data source have problems with grouping. If I change the order of groups to ascending, make Crystal sort on its own, everything works OK (apart from loosing part of functionality, because I donu2019t always want to sort a report by column that is used for grouping).

I also think that itu2019s quite easy to prepare simple example that will show the problem I submitted.

Regards

former_member183750
Active Contributor
0 Kudos

I'd suggest creating a phone case for this one as working this with a dedicated technician will be quickest and most efficient way to resolve this. If this is a CR issue, the case will be refunded to you. Phone cases can be created here:

http://store.businessobjects.com/store/bobjamer/en_US/pd/productID.98078100?resid=S6I@hgoHAkEAAGsiyV...

- Ludek

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]

Former Member
0 Kudos

I've prepared very simple example project that confirms my observation.

You can download it here:

[https://docs.google.com/leaf?id=0B2vTQkVW8tkqZmM3MjU4OGEtNTg1My00OGIwLWIwMTQtMTA0ZjFkYzBiYWMz&hl=pl&authkey=CMfs5OsJ|https://docs.google.com/leaf?id=0B2vTQkVW8tkqZmM3MjU4OGEtNTg1My00OGIwLWIwMTQtMTA0ZjFkYzBiYWMz&hl=pl&authkey=CMfs5OsJ]

Small description:

It's a VS2010 solution. In 'App_Data' directory you can find an example report, a dataset schema and three datatables (the same but sorted by other column). When you run this solution, you can load these datatables by choosing an appropriate radiobutton and see how they are handled by different versions of CR4VS2010 (32bit vs 64bit).

I've also attached in 'output_xxbit' directories the output from my servers. I hope the project is quite self explaining.

Regads,

former_member183750
Active Contributor
0 Kudos

Sorry. No time to test this. Note that phone cases do take precedence over forums. Testing of issues reported on the forums is at the discretion and available time of each one of us. Right now, too many phone cases are taking precedence.

- Ludek

Answers (0)