Using the Report Items Collection in Reporting Services
Sometimes, you may want to do calculations or use some value that has already been used in another object. By using the report items collection, you can get the value from whatever object you want and use it in a calculation.
For example, suppose you had a report that retrieved the total sales by day from the adventureworks database. You could quickly add an expression like the one below to return some form of label to let you know that it was a great day.
=IIF(ReportItems!SalesAmtForDay.Value>=1500,"Flippin Awesome Day!","Not so flippin awesome!")
Similarly, you could concatenate or aggregate values as well!
Take care,
Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consultants
Email: bmcdonald@pragmaticworks.com | Blog: BI Developer Network
Convert with DTS xChange | Develop with BI xPress | Process with TaskFactory | Document with BI Documenter