May 4, 2007 at 3:20 am
hi
i am using 2 pie graphs in my reporting services project.
anyway i encouter this problem
" The DataPoint expression for the chart ‘Graph1’ 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. "
in the data deilds section im using this , i need to get the % of the Feild ABC by group:
=Sum(Fields!ABC.Value,
"MainTable_Grouping_1") / Sum(Fields!ABC.Value, "Dataset0")
if i replace the scope parameter with just "MainTable" the error disappear and i can run the report but this way is wrong coz i get wrong results
i tried different scope parameter values like MainTable_Grouping_1 or MainTable_Grouping_2 .... always getting the same error
how can i resolve this issue any help plz?
May 8, 2007 at 11:26 am
The scope parameter is the name of the data set from which the field is being derived.
So your expression should work assuming:
1.) 'ABC' is a field in the data set 'MainTable_Grouping_1'
2.) 'ABC' is also field in the data set 'Dataset0'
What do your data set's look like?
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply