Reporting Services - Group Name in Page Title

Question

I have a report with one group (Office Name), which page is divided between each group, so data for one Office can be displayed on this page. How can I get this Office name in the page title?

I tried to create a hidden text box in the report details section that has the value “Office Name” and then refers to it in the page header, but I get the last value “Office Name” on page 1 and then it is blank on all the other pages .

Answer 1

I got it for work, and I will send an answer if someone else runs into this problem.

- , , .

Answer 2

, , .

, , Group. . Reporting Services ( SSRS)

BreakLocation Tablix, " " " ", , Disabled, ResetPageNumber PageName .

PageName. , .

, PageName, / PageName. ( SSRS)

=Globals!PageName

.

, , , , .

Answer 3

:

Private Shared vars As New System.Collections.Hashtable()

Public Function SetVar(ByVal key As String, ByVal value As String) As Object
    vars(key) = value
End Function

Public Function GetVar(ByVal key As String) As String
    return vars(key)
End Function

Add a text box to the group whose visibility is equal =Code.SetVar("MyGroupVar", "MyValue") = Nothing. This expression is true, so the text box will be hidden. I like to give this text box a color fill and text value Magic.

Now you can add a text box in the header value is =Code.GetVar("MyGroupVar").