The DataPoint expression for the chart ‘Graph1’

• Charbel-371270

  SSCrazy

  Points: 2260

  More actions

  May 4, 2007 at 3:20 am

  #177792

  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?

   

  ---

  If something's hard to do, then it's not worth doing.
  

• Ben Sullins-437405

  SSCertifiable

  Points: 5397

  More actions

  May 8, 2007 at 11:26 am

  #705020

  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?

  ---

  Cheers,

  Ben Sullins
  bensullins.com
  Beer is my primary key...