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
nsteele84Asked:
Who is Participating?
 
mlmccCommented:
WHat are the values in the field?

If you right click the field can you insert a summary?

Is the field a formula?
If so what is the formula?

mlmcc
0
 
nsteele84Author Commented:
The values in the fields are doubles
If I right clecik I can insert summary but I get the same result
No formulas in the field
0
 
mlmccCommented:
Are th evalues numbers or is Crystal seeing it as a string?

mlmcc
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
nsteele84Author Commented:
I get the number tab when I format object is there another way to tell?
0
 
mlmccCommented:
That is one way.  The other is just to hover over the field in the field explorer

Can you upload the report?

mlmcc
0
 
nsteele84Author Commented:
They all say they are number fields. I have uploaded the report
Report.zip
0
 
mlmccCommented:
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
0
 
nsteele84Author Commented:
It doesn't matter what the values are it always displays the number of records not a sum of the values
0
 
mlmccCommented:
I don't know.  The report seems to have the correct formulas.

mlmcc
0
 
James0628Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.