GROUP BY and SUM in Crystal Report

1

I need to do something relatively simple with Crystal Report but I can not.

I have a report like this:

OP   |    CLIENTE   |   PREÇO
1          João          10
1          João          20
1          João          30
2         Marcelo        15
3         Rodrigo        35 
3         Rodrigo        15
4         Pâmela         27

And I would like it to look like this:

OP   |    CLIENTE   |   PREÇO
1          João          60
2         Marcelo        15
3         Rodrigo        50 
4         Pâmela         27

That is, group by OPs and add the prices.

How do I do this ??

    
asked by anonymous 05.12.2014 / 14:56

1 answer

1

One way to do in CR is:

Insert a CLIENT Group

Enter the Customer name field

Enter the lines of detail

Enter a Total ( Add-on button - Inseir Summary), total by CLIENT group

Place detail line as Hide (Right mouse button - Hide Detailed Search )

    
05.12.2014 / 17:56