SQL Server Reporting Services Report and Group Variable References Video

By:   |   Comments   |   Related: > Reporting Services Formatting

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: https://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

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

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

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms