Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Reporting Services Report and Group Variable References Video


By:   |   Last Updated: 2015-04-23   |   Comments   |   Related Tips: > Reporting Services Formatting



 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

Report and group variables within SSRS report provide report designers with another tool to reuse code and ease the design process when dealing with complex calculations. Report variables can be used throughout a report whereas a group variable only is allowed within the scope of the group where it is implemented. A group variable is defined in the group properties window; similarly, report variables are defined in the report properties window. Like other objects within a SSRS report, a variable name must begin with a letter and cannot contain spaces, references to the variable are case sensitive, and report variables can be read-write or read-only (default). Finally, a variable can interact with SSRS embedded code or external code references. 

Be sure to read my full MSSQLTips.com tip at: http://www.mssqltips.com/sqlservertip/3231/sql-server-reporting-services-report-and-group-variable-references/

Key Learning Items

The video covers:

  • SQL Server Reporting Services Report Variables
  • Using Report Variables for SSRS
  • Using Group Variables in SQL Server Reporting Services
Read Companion Tips

Click Here



Last Updated: 2015-04-23


get scripts

next tip button



About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools