cross tab shows different totals on users machines with SAME DATASET

[chainedsqljunkie]

Crystal reports version 12.1.0.892
with crystal runtime CRRuntime_12_0_mlb.msi installed on users machines

reportdocument object datasource is set in c# from datatable retrieved from SQL with 29 rows

report has a running total count of details, reset on change of group 3 "status"

at end of group 3 is cross tab, summarized field is the running total, row is set to status

totals are correct on my machine and everyone elses

end of group 2 "dealer" contains crosstab, summarized field is the running total, rows is set to status and dealer
the sum is perfect on my machine, showing 29 details, on EVERYONE elses machine it shows 57

end of group 1 "agent" contains crosstab, summarized field is the running total, rows are set to status, dealer and agent.the sum is perfect on my machine, showing 29 details, on EVERYONE elses machine it shows 57

the report footer has the same crosstab as the group 1 footer, and I get the same results

I am tearing my hair out. I tried reinstalling the run time for the users, making a new report that accesses a different stored proc with the same query, to make certain I wasn't hitting a different schema, and the results are the same. 29 for me, 57 for everyone else.

 

[chainedsqljunkie]

the dataset is the same, so all these instances have 29 details

 

[Madawc]

I answered your other post. Please stick to just one forum in future.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP