The location of the expression in the report influences which data is in scope for aggregate calculations.Īdd sparklines to a table or matrix Specify a minimum and maximum range for chart axes to align nested instances in a table or matrix.Īdd indicators to a table or matrix Specify a minimum and maximum scale for the gauge to align nested instances in a table or matrix. Write expressions that use aggregate functions Specify which data to aggregate. Understanding data scope helps you to get the results that you want when you do the following: Use the following descriptions to help differentiate which meaning of scope applies:ĭata scope Data scope is a hierarchy of scopes that the report processor uses as it combines report data and report layout, and builds out data regions such as tables and charts on which to display the data. You will see the term scope in topics that relate to expression evaluation, aggregate function syntax, conditional visibility, and also in error messages related to these areas. Scope can specify the data to use for evaluating an expression, the set of text boxes on a rendered page, the set of report items that can be shown or hidden based on a toggle. When you write expressions, you will find that the term scope is used in multiple contexts in paginated reports.
APPLIES TO: ✔️ Microsoft Report Builder (SSRS) ✔️ Power BI Report Builder ✔️ Report Designer in SQL Server Data Tools