Crystal reports group, sum 
Author Message
 Crystal reports group, sum

Hello everybody,

I have a problem with Crystal Reports V4.6.1.0.

I have a query with the data value1, value2 and value3.

The report looks like this:

pageheader      value1  value2  value3


detail          1       1200    1000    value3 is not displayed in the
                1       1600    1000    detail, but it has always the same
                1       156.55  1000    value during the gruop.
                1       345.67  1000    

groupfooting    1       3320.22 1000    value3 is only displayed in

detail          2       2300    2000    The data is grouped by value1.  
                2       5000    2000
                2       4500    2000

groupfooting    2       11800   2000    

reportfooting           15120.22 10000

I want to sum only the data of value3 in the groupfooting.
So there should be displayed 3000 not 10000.
Crytel reports is summing the data of value3 of every detailline.
What am I doing wrong ?

Thanks for any tip.

Holger Keil

Fri, 08 Nov 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Report showing BOTH Aggregate Sum of Display records and Total Sum by Group

2. Seperate Grouping in Crystal Report Report

3. Crystal report Sum

4. Crystal Reports: Creating a carry sum

5. help: Crystal Reports with Variables and Sums

6. HLP: Crystal Reports sub-section sum problem

7. Crystal Report: Sum of formula

8. Crystal Reports: Creating a carry sum

9. I want to make commutative sum using crystal report 6

10. Summing things in crystal report

11. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

12. Crystal Reports: add/delete groups dynamically and starting a new page dynamically


Powered by phpBB® Forum Software