SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Using the Report Items Collection in Reporting Services

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!

Download This Example

 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



No comments.

Leave a Comment

Please register or log in to leave a comment.