Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

possible to use a 'cell reference' in SSRS table for a calculated column? Expand / Collapse
Author
Message
Posted Monday, August 25, 2014 11:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 4:45 PM
Points: 308, Visits: 839
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.
Post #1607152
Posted Monday, August 25, 2014 3:53 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:27 PM
Points: 184, Visits: 8,268
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.
Post #1607273
Posted Tuesday, August 26, 2014 11:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 4:45 PM
Points: 308, Visits: 839
doug.brown, you rock. Exactly right.
Post #1607555
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse