Last post May 02, 2011 11:21 AM by kumar_kislay
None
0 Points
2 Posts
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.
Member
192 Points
54 Posts
Apr 13, 2011 05:52 PM|codemihir1|LINK
post your query, what are you trying to achive
60 Points
30 Posts
Apr 14, 2011 02:00 AM|ravindra.patil|LINK
Hi Kumra_kislay,
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.
None
0 Points
2 Posts
how to have more than one group by clause and summation of data fields as well in group by footer...
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.
Member
192 Points
54 Posts
Re: how to have more than one group by clause and summation of data fields as well in group by fo...
Apr 13, 2011 05:52 PM|codemihir1|LINK
post your query, what are you trying to achive
Happy Coding :)
Remeber to Mark as Answer if this post helped you.
Member
60 Points
30 Posts
Re: how to have more than one group by clause and summation of data fields as well in group by fo...
Apr 14, 2011 02:00 AM|ravindra.patil|LINK
Hi Kumra_kislay,
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.
MSTS (SP2010 Application Deveopment)
None
0 Points
2 Posts
Re: how to have more than one group by clause and summation of data fields as well in group by fo...
May 02, 2011 11:21 AM|kumar_kislay|LINK
Thanks for your reply. yes we can ihave that. i tried and found the solution.