Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Points: 6853

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