December 3rd, 2012, 01:09 AM
How to use group clause in Crystal Report?
I want to populate my report as the above way using Crystal report (visual studio 2005). Here we do summition of column8 by grouping of column1 where column2 ='dd'
column1 column2 ..... column8 Sum diff
a dd ..... 12
a dd ..... 11 23
a ee ..... 33 33 -10
b dd ..... 25 25
b cc ..... 10
b ss ..... 22 32 -7
c aa ..... 30 30 30
and same where column2<>'dd'. but if i use query direct then i get single line output whereas i want to show all the rows for column1...column8 and then field sum and field diff.
May anyone suggest how to print report in above way?
Thanks in advance.
Last edited by GremlinSA; December 3rd, 2012 at 02:40 AM.
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.