Points: 7053

9/4/2019 11:07:03 AM

SSRS - Refer to a report cell in a formula

* This article, and all our great SQL Server Reporting Services documentation, Is available on the SQL Server Reporting Services menu

I'll be honest - the main reason I write these articles is because I can't remember the techniques for 5 minutes. If I blog it and put it on the menu I can always find it again. 

The topic du jour is how to refer to a report field in a formula. 

Now, I'm 100% SQL, I do everything in SQL. If it can be done there, that's what I do. 

But in this case there was an odd grouping going on in the report, and I needed to refer to a report cell in a formula. The technique is below

Version: Unknown or N/A
Section: SSRS
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables