Built-in Globals and User references in a paginated report (Report Builder)
Applies to:
Microsoft Report Builder (SSRS)
Power BI Report Builder
Report Designer in SQL Server Data Tools
The built-in fields collection, which includes both the Globals and the User collections, represent global values provided by Reporting Services when a paginated report is processed. The Globals collection provides values such as the name of the report, the time when report processing began, and current page numbers for the report header or footer. The User collection provides the user identifier and language settings. These values can be used in expressions to filter results in a report.
Note
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Use the Globals collection
The Globals collection contains the global variables for the report. On the design surface, these variables appear prefixed by an & (ampersand), for example, [&ReportName]
. The following table describes the members of the Globals collection.
Member | Type | Description |
---|---|---|
ExecutionTime | DateTime | The date and time that the report began to run. |
PageNumber | Integer | The current page number relative to page breaks that reset the page number. At the beginning of report processing, the initial value is set to 1 . The page number increments for each rendered page.To number pages within page breaks for a rectangle, a data region, a data region group, or a map, on the PageBreak property, set the ResetPageNumber property to True. Not supported on tablix column hierarchy groups. PageNumber can only be used in an expression in a page header or page footer. |
ReportFolder | String | The full path to the folder containing the report. This item doesn't include the report server URL. |
ReportName | String | The name of the report as it is stored in the report server database. |
ReportServerUrl | String | The URL of the report server on which the report is run. |
TotalPages | Integer | The total number of pages relative to page breaks that reset PageNumber. If no page breaks are set, this value is the same as OverallTotalPages. TotalPages can only be used in an expression in a page header or page footer. |
PageName | String | The name of the page. At the beginning of report processing, the initial value is set from InitialPageName, a report property. As each report item is processed, this value is replaced by the corresponding value of PageName from a rectangle, a data region, a data region group, or a map. Not supported on tablix column hierarchy groups. PageName can only be used in an expression in a page header or page footer. |
OverallPageNumber | Integer | The page number of the current page for the entire report. This value isn't affected by ResetPageNumber. OverallPageNumber can only be used in an expression in a page header or page footer. |
OverallTotalPages | Integer | The total number pages for the entire report. This value isn't affected by ResetPageNumber. OverallTotalPages can only be used in an expression in a page header or page footer. |
RenderFormat | RenderFormat | Information about the current rendering request. For more information, see RenderFormat in the next section. |
Members of the Globals collection return a variant. If you want to use a member of this collection in an expression that requires a specific data type, you must first cast the variable. For example, to convert the execution time variant into a Date format, use =CDate(Globals!ExecutionTime)
. For more information, see Data types in expressions (Report Builder).
RenderFormat
The following table describes the members for RenderFormat.
Member | Type | Description |
---|---|---|
Name | String | The name of the renderer as registered in the RSReportServer configuration file.Available during specific parts of the report processing/rendering cycle. |
IsInteractive | Boolean | Indicates whether the current rendering request uses an interactive rendering format. |
DeviceInfo | Read-only name/value collection | Key/value pairs for deviceinfo parameters for the current rendering request. String values can be specified by using either the key or an index into the collection. |
Examples
The following examples show how to use a reference to the Globals collection in an expression:
This expression, placed in a text box in the footer of a report, provides the page number and total pages in the report:
=Globals.PageNumber & " of " & Globals.TotalPages
This expression provides the name of the report and the time it was run. The time is formatted with the Microsoft .NET Framework formatting string for short date:
=Globals.ReportName & ", dated " & Format(Globals.ExecutionTime, "d")
This expression, placed in the Column Visibility dialog for a selected column, displays the column only when the report is exported to Excel. Otherwise, the column is hidden.
EXCELOPENXML
refers to the format of Excel that is included in Office 2007.EXCEL
refers to the format of Excel that is included in Office 2003.=IIF(Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", false, true)
Use the User collection
The User collection contains data about the user who is running the report. You can use this collection to filter the data that appears in a report. For example, you can show only the data of the current user, or to display the UserID, like in a report title. On the design surface, these variables appear prefixed by an & (ampersand), for example, [&UserID]
.
The following table describes the members of the User collection.
Member | Type | Description |
---|---|---|
Language | String | The language of the user running the report. For example, en-US . |
UserID | String | The ID of the user running the report. If you're using Windows Authentication, this value is the domain account of the current user. The Report Builder security extension determines the value, which can use Windows Authentication or custom authentication. |
Use locale settings
You can use expressions to refer to the locale settings on a client computer through the User.Language value to determine how a report appears to the user. For example, you can create a report that uses a different query expression based on the locale value. The query might change to retrieve localized information from a different column depending on the language returned. You can also use an expression in the language settings of the report or report items based on this variable.
Note
While you can change the language settings of a report, you must be careful about any display issues this may cause. For example, changing the locale setting of the report can change the date format in the report, but it can also change the currency format. Unless there is a conversion process for the currency, this may cause the incorrect currency symbol to be displayed in the report. To avoid this, set the language information about the individual items that you want to change, or set the item with the currency data to a specific language.
Identify UserID for snapshot or history reports
In some cases, reports that include the User!UserID variable fail to show report data that is specific to the current user who is viewing the report.
Related content
Expressions (Report Builder)
Expression dialog (Report Builder)
Data types in expressions (Report Builder)
Format numbers and dates (Report Builder)
Expression examples (Report Builder)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre