Hi , i have query like below SELECT tf.FundCode as [Fund#], tf.ShortDescription as [Fund Source], tp.CIPINo as[CIP#], tp.Title as[Project Title], SUM(tfa.AppropriationToDate) as [Appropriated to Date], FROM tOPFundAllocation as tfa INNER JOIN tCDFund as tf on tfa.Fund_Key=tf.Fund_Key INNER JOIN tOPRequest as tr on tfa.Request_Key=tr.Request_Key INNER JOIN tOPProject as tp on(tp.Project_Key=tr.Project_Key) WHERE tfa.ProcessPhase_Key=@Phase and tr.FiscalYear=@FiscalYear GROUP BY tf.FundCode, tf.ShortDescription, tp.CIPINo, tp.Title, tfa.FutureAmount Reports table Column1(CIP#) Column2(Project Title]) column3(Appropriated to Date) 302 (fundcode) testing(Fund Source) 1 title1 500 2 titlle2 1000 303fundcode) testing 2(Fund Source) 3 title 3 2000 4 title4 6000 my report should look like this, i think i need to apply grouping how do i do it? i could not paste the image thats y i descriped my table like above where 1,2,3,4 are cip# and title1,title2,title3,title4 are project title 302,303 are fund# and testing1,testing2 are fundsource Thanks, Saraswathy Thanks, Saraswathy Kumaravelu

Hi , Check the below link. In a tablix data region, click in the table to display the Grouping pane. Drag a field from the Report Data pane to the Column Groups pane. (So in your case fund#) Drop the field above or below the group hierarchy using the guide bar to place the group as a parent group or a child group to an existing group.The group is added with a default name, group expression, and sort expression that is based on the field name. Drag the Group Columns to the Detail section. In you case it would be (cip# and ProjectTitle#) For more info check the below link. http://msdn.microsoft.com/en-us/library/dd220419.aspx Hope It works, Regards, PS Regards, PS