nsteele84
asked on
Problem with Running Totals in cr.net visual Studio 2008
Hi
I am trying to use running totals in my report, but what is happening is it is displaying the total number of records not the sum of the field. Heres what I am doing
1) I select new running total.
2) I select the field from the report
3) I select sum as the type of summary
4) Evaluate set to each record
5) Reset set to never
I do have groups in the report if that makes a difference.
This used to work in VS 2003 has something changed?
Regards Nick Steele
I am trying to use running totals in my report, but what is happening is it is displaying the total number of records not the sum of the field. Heres what I am doing
1) I select new running total.
2) I select the field from the report
3) I select sum as the type of summary
4) Evaluate set to each record
5) Reset set to never
I do have groups in the report if that makes a difference.
This used to work in VS 2003 has something changed?
Regards Nick Steele
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are th evalues numbers or is Crystal seeing it as a string?
mlmcc
mlmcc
ASKER
I get the number tab when I format object is there another way to tell?
That is one way. The other is just to hover over the field in the field explorer
Can you upload the report?
mlmcc
Can you upload the report?
mlmcc
ASKER
They all say they are number fields. I have uploaded the report
Report.zip
Report.zip
The report seems to be correct.
Are the totals correct based on the data you have
ie values like
1, 2, -2, 4, -3, 4 add to 6 and there are 6 values
mlmcc
Are the totals correct based on the data you have
ie values like
1, 2, -2, 4, -3, 4 add to 6 and there are 6 values
mlmcc
ASKER
It doesn't matter what the values are it always displays the number of records not a sum of the values
I don't know. The report seems to have the correct formulas.
mlmcc
mlmcc
The sample report seems simple enough. Of course I can't see your data to see what kinds of values are in dbl1, but the running total definition looks fine.
I'd try changing the running total to some other type of summary, like average, minimum or maximum, and see what you get.
Also, maybe you could post a screenshot of the report after you've run it, showing the values in dbl1 and the incorrect running totals. Not to doubt you, but I'd really like to see it for myself. :-) Or, if you could use the "Save data with report" option and u/l the report with some saved data, so we could run the report on our systems and see what happens.
James
I'd try changing the running total to some other type of summary, like average, minimum or maximum, and see what you get.
Also, maybe you could post a screenshot of the report after you've run it, showing the values in dbl1 and the incorrect running totals. Not to doubt you, but I'd really like to see it for myself. :-) Or, if you could use the "Save data with report" option and u/l the report with some saved data, so we could run the report on our systems and see what happens.
James
ASKER
If I right clecik I can insert summary but I get the same result
No formulas in the field