Cross Tab Crystal Report

Hi Ramco,
you can use the PIVOT function in your query. The PIVOT function allows you to transform the rows of a table into columns, based on a pivot column and pivot values.
 

SELECT 
  PartyCode, 
  PartyName, 
  ItemCode, 
  Description, 
  [Sep22], 
  [Aug22], 
  [Jul22], 
  [Jun22], 
  [May22], 
  [Apr22], 
  Total 
FROM 
  (
    SELECT 
      T0.Date, 
      T0.cardcode as PartyCode, 
      T0.cardname as PartyName, 
      T1.ItemCode, 
      T1.Description, 
      SUM(T1.Total) as Total 
    FROM 
      SaleHeader T0 
      INNER JOIN SalesDetail T1 ON T0.doc = t1.doc 
    GROUP BY 
      T1.ItemCode, 
      T0.date, 
      T0.cardcode, 
      T0.cardname, 
      T1.Description
  ) t PIVOT (
    SUM(Total) FOR Date IN (
      [Sep22], [Aug22], [Jul22], [Jun22], 
      [May22], [Apr22]
    )
  ) AS p