Last post May 02, 2011 11:21 AM by kumar_kislay
Apr 13, 2011 10:35 AM|kumar_kislay|LINK
How do we have more than one group by clause in SSRS and summation of all fields in group by footer clause !
Is it possible to have nested group by clause in SSRS and summation of reports fields in those group by footer.
thanks in advance for your response.
Apr 13, 2011 05:52 PM|codemihir1|LINK
post your query, what are you trying to achive
Apr 14, 2011 02:00 AM|ravindra.patil|LINK
Yes it is possible to have multiple groups in SSRS. The groups can be separate as well as nested. So that you can have different summation fields and totals.
In report footer you cannot add any groups.
May 02, 2011 11:21 AM|kumar_kislay|LINK
Thanks for your reply. yes we can ihave that. i tried and found the solution.