Hi, I have To generate a report in which there are 13 columns.The columns are PIMCategoryDescription ,[Product Description],[Distributor Item Code],[Brand Name] ,[Pack Size] ,Manufacturer ,[Mfr Item Code],Stocked ,[Follow up] ,ParentName,SystemName,[Current Product],DNUSFS ,[cases shipped],[Cost Per Case], [Saving Per Case] , [Annualized Savings],[FinalSum2],TempAnnaSaving. Let suppose that there are 10 rows of records in which [Crrent product] has a value of 'current product' and 'match' in a alternate basis, [cases shipped] has a integer value for each current product and match.PIMCategoryDescription has same value for all records but diffrent in terms of current product and match that means same for each current product and each match. Now i have to goupe these in a manner so that i found the sum of all cases shiped for all current product and match records,that means the sum of cases shiped of 5 current product in one row and the sum of cases shiped of 5 matches in one rows. how i can do it??????

Hi Vikram Goswam, From the information posted, I was still confused with the exact way you want to group data. I can see the dataset structure of your report. For further assistant, could you please provide me with more sample data of the report, and expected result based on these sample data. An image attached will be much more appreciated. Generally speaking, we can add a group by the steps in MSDN article: http://msdn.microsoft.com/en-us/library/dd220419(v=SQL.100).aspx. And add totals for groups by the steps in MSDN article: http://msdn.microsoft.com/en-us/library/dd239342(v=SQL.100).aspx. Thanks, Lola Wang Please remember to mark the replies as answers if they help.