Configuring Reports with SSRS - Pro SQL Server 2012 BI Solutions - page 714

1. Highlight the background of the report design surface to access the Visual studio

Report menu. This should force the Report menu to appear (figure 17-3 ) .

2. in the Visual studio Report menu, click the Report Properties menu option.

3. when the Reports Properties dialog window appears, click the Variables page on the

left side of that screen (figure 17-22 ) .

4. Add two variables as indicated in figure 17-22 and Table 17-1 .

Table 17-1. Report Variable Settings

Name Value

ReportName Add the Report Name

ReportOwner Add the Report Owner

Configuring Expressions

with the variables in place, we can now use them as well as our expressions. follow the next few steps to
create the various expressions used within the report header and footer.

1. Configure the value property of each of the four text boxes on our report by right-

clicking each of the three empty textboxes in the header and right-clicking the single
textbox in the report footer. select the Expressions option from the context menu for
each (figure 17-16 ) .

2. when the Expressions dialog window appears, configure the expression for each of

the three textboxes, as indicated in Table 17-2 .

Table 17-2. Expression Code for Report Items

Textbox Item Expression

= Variables!ReportName.Value TextboxReportLabel

= Variables!ReportOwner.Value TextboxOwnerLabel

= FormatDateTime(Today, DateFormat.LongDate)

TextboxCreatedOnLabel

= "Page Number: "
& Globals!PageNumber
& " of "
& Globals!TotalPages

TextboxPageNumber