All, I am having one Group in a table in ssrs 2008 r2 report. I have included group footer while creating it to display "Sub-Total" of some amount values for that group. Now, I need a output in that if that group has more than one row then only it should display sub-total for it, otherwise if the group has only one row then it should not display sub-total row. Is it possible to do? Thanks,

Does anyone have any idea on this ?

Hi BI, We aren't able to understand your question properly. Can you elaborate or explanation more clearly, if possible with an exmaple? Also, if I'm not wrong than you want two group footer, right? In that case you can copy and paste group footer, or else tell us in more detail. Thank You KumarKG, MCTS

Thanks Challen Fu, Your solution worked well for me.If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood