Hi
I have below code & i want Data to be displayed in Cross-Tab report like below.
Select T0.Date,Max(T0.cardcode) PartyCode,Max(T0.cardname) PartyName, T1.ItemCode,Max(T1.Description) Dscription,Sum(T1.Total) Amount from SaleHeader T0 inner join SalesDetail T1 on T0.doc = t1.doc group by T1.ItemCode,T0.date
Total Sep'22 Aug'22 Jul'22 Jun'22 May'22 Apr'22
Item 1 12 2 10
Item 2 5 5
2 5 10