chainedsqljunkie
Programmer
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 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.
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 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.