Last post May 30, 2011 04:57 AM by You-Hu Fu
May 20, 2011 05:38 AM|jyoti.varma247|LINK
I am using SSRS and have a group named "G_Invoice" . In the footer I need to total the group's total. I used the following lines
=Sum( Fields!InvoiceAmount.Value ,"G_Invoice") in the textbox .
I also tried
In both the cases, it shows an error
How to achieve it?
May 26, 2011 04:05 AM|Nishantg|LINK
If it is a group total then it will come for all group, so I am not clear that what you want to show in your footer.
May 27, 2011 04:50 AM|Jonathan Shen – MSFT|LINK
I am a little confused. Would you please add more details?
May 30, 2011 04:57 AM|You-Hu Fu|LINK
Please change your expression =Sum( Fields!InvoiceAmount.Value ,"G_Invoice") to =Sum( Fields!InvoiceAmount.Value ,"DatasetName")
Note: please replace the DatasetName with your report's dataset name.
If the issue still exist, please feel free to ask.