Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 18, 2004

MSSQL Server Reporting Services: Reporting Services Basics: Create a Reusable Template Report - Page 7

By William Pearson

Create a Page Footer

We now have a header, and can move to the creation of a Page Footer. Within the footer, we will insert the additional variables that the client has requested.

1.  Click anywhere in the Layout area, once again, to ensure it is enabled.

2.  Select Report from the main menu atop the Report Designer.

3.  Select Page Footer from the menu that appears,

We see the new Page Footer section in the Layout area, as shown in Illustration 19.

Click for larger image

Illustration 19: The Footer Section Appears on the Layout Tab (Compacted)

We will work within the Page Footer section to manage the objects and formats that appear in the footer sections of the various pages of the report. As we noted when discussing the Page Header section, we can insert various objects into the footer, but these do not include data regions (lists, matrices, tables, and charts), and some other objects that are typically associated with the report Body section.

4.  Insert a Textbox into the Page Footer section of the Layout area.

5.  Click the Textbox in the Footer section, to ascertain that it is selected.

6.  Open the Properties window for the Textbox.

7.  In the Properties window, ensure that the settings shown in Table 4 are in place.







Verdana Ref















Table 4: Textbox Properties Settings

The Textbox Properties window appears, with our settings, as depicted in Illustration 20.

Illustration 20: Textbox Properties Window with Settings

Now we will add a global variable to the footer, using the Value setting within the Textbox Properties window where we have just completed the above settings.

8.  Click within the Value setting in the Textbox Properties window to select it.

9.  Click the selector button (the down arrow) that appears.

10.  Select <Expression ...> from the selector, as shown in Illustration 21.

Illustration 21: Click Expression from the Value Selector

The Edit Expression dialog appears.

11.  Type the following after the "=" ("equals") sign in the Expression area of the dialog:

"System User: " &

NOTE: As a general rule, be sure to provide a space on either side of the "&" (ampersand) sign, when using it to concatenate text, fields, etc. in expressions, as we will be doing in this, and subsequent, steps.

12.  Click the "+" ("plus") sign to the immediate left of Globals, under Fields, on the left side of the Edit Expression dialog, to expand it.

13.  Click UserID under Globals to highlight it.

14.  Click the Append button.

The UserID expression component appears in the Expression area of the dialog. The Edit Expression dialog should appear as depicted in Illustration 22.

Illustration 22: The Edit Expression Dialog with Our Additions

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM