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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Feb 22, 2005

MSSQL Server Reporting Services : Black Belt Administration: Execution Log Performance and Audit Reports - Page 8

By William Pearson

At this stage, we need to add the data fields Report Type and Path (the file system location for the report file) to the DataSet. To do so, we will modify the DataSet on the Data tab.

21.  Click the Data tab.

22.  Click the Graphical Query Designer button, as necessary, to shift to the graphic designer, which consists of a toolbar and four panes, as shown in Illustration 27.

Click for larger image

Illustration 27: Graphical Query Designer (Compact View) - with "Shift Button" Circled

23.  Right-click in the white space to the right of the tables, within the Diagram pane.

24.  Select Add Table ... from the context menu that appears, as depicted in Illustration 28.


Illustration 28: Select Add Table ...

The Add Table dialog appears, defaulted to the Tables tab.

25.  Select Report Types from the tables listed in the dialog, as shown in Illustration 29.


Illustration 29: Select the Report Types Table ...

26.  Click Add.

27.  Click Close, to dismiss the Add Table dialog.

The Report Types table appears, along with the other tables, in the Diagram pane.

28.  In the Report Types table, click the checkbox to the immediate left of Name, to select the field into the existing query.

29.  In the Grid pane (the pane containing rows and columns, just below the Diagram pane), type the following into the Alias column of the grid for the Name row (likely the bottom row in the Grid pane), to replace the default entry "Expr1:"

Type

30.  In the Reports table, click the checkbox to the immediate left of Path, to select the field into the existing query.

The Diagram and Grid panes appear, with our selections / additions, as depicted in Illustration 30.


Illustration 30: Our Selections and Additions in the Diagram and Grid Panes (Circled)

Now, let's go to the Layout tab and make the additions to the report layout.

31.  Click the Layout tab.

32.  Click the box containing the words "Total Executions."

The gray column and row headers for the table data region appear.

33.  Right-click the column header above the box containing the words "Total Executions."

34.  Select Insert Column to the Right from the context menu that appears, as shown in Illustration 31.


Illustration 31: Inserting a Column into the Table Data Region

The new column appears.

35.  Type the following into the top text box of the new column:

Type

36.  Click the Type field in the Fields List of the Fields window.

37.  Drag the field to the bottom row of the new column we created, and labeled Type above.

38.  Drop the field into the textbox.

The field appears in the bottom textbox of the new Type column, as depicted in Illustration 32.


Illustration 32: The Type Field Appears in the New Type Column

NOTE: If the Fields window is not initially visible in the Report Designer, select View --> Fields from the main menu to resurrect it.

39.  Right-click the column header for the column we just added above, now labeled Type. (Click anywhere in the column to make the header reappear, if necessary).

40.  Select Insert Column to the Right from the context menu that appears, once again.

The new column appears.

41.  Type the following into the top text box of the new column:

Location

42.  Click the Path field in the Fields List of the Fields window.

43.  Drag the field to the bottom row of the new column we created, and labeled Location above.

44.  Drop the field into the textbox.

The field appears in the bottom textbox of the new Location column as shown in Illustration 33.


Illustration 33: The Path Field Appears in the New Location Column



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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