Crystal reports group, sum

Crystal reports group, sum

Post by WGH » Tue, 23 May 2000 04:00:00



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:
------------------------------------------------
reporthaeder

pageheader      value1  value2  value3

groupheader    

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
                                        groupfooting.

grouheader      
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

 
 
 

1. Seperate Grouping in Crystal Report Report

I am trying to create a report along the following lines, does anyone
know if it can be done using crystal reports.

^       Customer Name
I
I^      Payment 1 recived
I I     Payment 2 recived
I I    
Iv      Payment X recived
I
I^      Electricity used 1
I I     Electricity used 2
I I
Iv      Electricity used Y
v

The data comes from three tables Customer, Invoice,Meter Reading, and
the second two are linked to the Custome table by the CustomerID.

All help gratfully recived
Nick Charsley

'the question of whether a computer can think is no more interesting
than the question of whether a submarine can swim'
                                      attributed to  Edsgar Dijkstrs

2. Problem with DBase index files and Delphi (UPPER, STR, etc)

3. help: Crystal Reports with Variables and Sums

4. New manual chapters

5. Crystal report Sum

6. US-CA-IMPLEMENTATION SPECIALIST

7. Crystal Reports: Creating a carry sum

8. Need Audit script

9. How to sum only grouped fields in report ?

10. GROUP SUM with WHERE in REPORT

11. Editing Crystal reports without Crystal Reports

12. Crystal Report 6 and Crystal Report 8

13. Announcement: Easily integrate Crystal Reports with Remedy with UFLTimeZone for Crystal Reports