locked
Group Total in Footer (SSRS) RRS feed

  • Question

  • User1419903475 posted

    Hello,

    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

    =RunningValue(Fields!InvoiceAmount.Value ,sum,"G_Invoice")

    In both the cases, it shows an error

     

    The Value expression for the textbox ‘textbox27’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

     

    How to achieve it?

     

    Thanx

     

     

    Friday, May 20, 2011 5:38 AM

Answers

  • User1471008070 posted

    Hi,

    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.

    Thanks,
    Challen Fu

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 30, 2011 4:57 AM

All replies

  • User-830595639 posted

    Hi,

    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.

    Thursday, May 26, 2011 4:05 AM
  • User583989486 posted

    Hi

    I am a little confused. Would you please add more details?

    Best regards,

    Jonathan

    Friday, May 27, 2011 4:50 AM
  • User1471008070 posted

    Hi,

    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.

    Thanks,
    Challen Fu

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 30, 2011 4:57 AM