Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
 Posted - 2011-10-25 : 02:48:24
|
| Im using SSRS and have a group name Group_Metric". I need the total for the qty and inventory value. here is the line in details for qty=Sum(Fields!Qty.Value,"Group_Metric") and Inventory value =sum(Fields!InventoryValue.Value,"Group_Metric").Then in Row group, click the add total, after and create a new lines. for qty =Sum(Fields!Qty.Value,"Group_Metric") and =sum(Fields!InventoryValue.Value,"Group_Metric"). run the report i got an error.Here is the error message:The Value expression for the textbox ‘textbox71’ 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.waht is the cause of this error?regards,JOV |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 04:17:13
|
| total row is not on the scope of group. i think below is sufficient=Sum(Fields!Qty.Value)=sum(Fields!InventoryValue.Value)if its not working try giving container scope=sum(Fields!InventoryValue.Value,"Tablename")...------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Villanuev
Constraint Violating Yak Guru
478 Posts |
Posted - 2011-10-25 : 04:53:09
|
| Thanks Visakh16. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-25 : 04:54:15
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Add group total in footer for calculation