Solved

crystal reports sum() with no grouping

Posted on 2013-05-15
2
324 Views
Last Modified: 2013-05-16
Hi

I am producing a report in crystal reports for VS 2010

The report is listing a number of items, each categorised but not grouped.

I have 3 categories to make a sum of the units in each... so I have tried something like this

example:

nuts 3
bolts 10
nuts 3
washers 8
nuts 4
bolts 5
washers 3

Totals:
nuts: 10
bolts: 15
washers: 11



Local NumberVar tot;
if {Command.group} = 0 Then
    tot := tot + {Command.units};

tot

Open in new window


but this isn't working as expected... how can I achieve the results I need?
0
Comment
Question by:cycledude
  • 2
2 Comments
 

Accepted Solution

by:
cycledude earned 0 total points
ID: 39170570
I got this working now...

I used 'running total fields' and put a formula in there like

{command.group} = 0
{command.group} = 1
{command.group} = 2


so I have a field per category and they are calculating the sums correctly now.

Happy days

;o)
0
 

Author Closing Comment

by:cycledude
ID: 39170571
for future reference
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now