possible to use a 'cell reference' in SSRS table for a calculated column?

  • In the manner that we might do in Excel: A1 + B1 / A25 + B25, can we do something similar in SSRS. I have two cells in a table whose values I want to divide.

    --Quote me

  • You can do it in an expression with ReportItems, like this:

    =ReportItems!Textbox1.Value / ReportItems!Textbox2.Value

    Where Textbox1 and Textbox 2 are the actual names of the fields you want to divide.

  • doug.brown, you rock. Exactly right.

    --Quote me

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply