0

I've created a grid - based on its own data set.
I've calculated the grand total of a column by summing all the output.
I now need to access that text box/element (which I named grandtotal).
I have a new text box at the bottom of the report - in that field I want to display (once more) the grandtotal I can't seem to find good instructions for doing this.

YelizavetaYR
  • 1,611
  • 6
  • 21
  • 37

1 Answers1

0

Nope that's not possible. Only fields/parameters/constants/calculated expressions can be evaluated. The sum totals is calculated internally by SSRS engine which can't be accessed. Do the calculation(summation) in a dataset and use it instead. See a similar question here.

Community
  • 1
  • 1
SouravA
  • 5,147
  • 2
  • 24
  • 49
  • There is no way to say - Textbox30 (or Grandtotal since i've renamed it). and simply to access that data - even if its on the fly. – YelizavetaYR Jan 08 '15 at 21:26
  • Exactly that's what I am saying. You need to do the summation inside a dataset and then pull it elsewhere. – SouravA Jan 08 '15 at 21:27
  • 1
    That seems to duplicate the work - but since that is the only option I will do so. Thank you. – YelizavetaYR Jan 14 '15 at 19:09