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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.