Hi, We have a requirement where we need to add group data for Report footer. But we do not have the report footer concept in SSRS 2005. Following is the data to be present on footer: X Count Totals: A 2 B 3 I created a data set with text: Select x,count(x) as count from table group by x. But I am unable to link this text to the footer. Can anybody help me for this.

hi, You can fomat your data using Rows and column grouping. if you are facing problem using grouping then paste the input data table column names and required output.I will try it on my system,.Thanks, Pranil Yambal | MCTS | Pranil.Yambal@hotmail.com

Hi Aneeshporus, I think you may refer to the article below for detailed information, Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)! http://blogs.msdn.com/b/robertbruckner/archive/2009/08/10/tablix-multiple-subtotals-are-easy-aka-goodbye-inscope.aspx The article described a similar scenario, and provided a way to work it. Thanks, Eileen