By Carina C.

Terms used in Reporting Services:

·         Data Source

·         Data Set: query related to a data source

·         Data Region: object that displays data

Types of Data Regions:

·         Table: Tabular report

·         Matrix

·         List: free form enlisted data

·         Graphics

Creating Reports in Reporting Services

Reporting Services offers the following ways to create a Report:

·         Add New Report Wizard (Templates)

·         Add/Add New Item. Creates a blank report

·         Import Reports. It allows the importation of reports from an Access database

Report using Tables

Data View

1.       Select <New Dataset…>

2.       Assign a name to the Dataset and specify the Data Source that it will use

3.       Select the Command type

4.       Assign the query or Store Procedure

Layout

1.       Create a table, using toolbox, in the body section

2.       Insert the fields that the report needs

3.       Add Header and Footer

Preview

Generate the preview of the on-screen report. The report can be exported as:

·         XML

·         CVS

·         PDF

·         Web Archive

·         Excel

Data tab

 Layout tab

Preview tab

Reporting Services Capabilities:

Calculations and Formats. Reporting Services allows use of the several functions, such as the following:

• Standard Operators
• +, -, *, /
• Concatenation
• &
• Aggregate Functions
• Sum, Count, Avg, Min, Max, etc
• Condittional
• IIf()
• Globals
• PageNumber
• TotalPages
• ExecutionTime, etc

Reporting services also allows the usage of the following types of parameters:

·         Text Parameters

·         Drop-Down Parameters

·         Multi-Value Parameters

It is also possible to use a report field using the function:

·         ReportItems