Code:
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
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'
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.