welcome to this evening s technet event n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Welcome to this evening’s TechNet Event PowerPoint Presentation
Download Presentation
Welcome to this evening’s TechNet Event

Loading in 2 Seconds...

play fullscreen
1 / 55

Welcome to this evening’s TechNet Event - PowerPoint PPT Presentation


  • 111 Views
  • Uploaded on

Welcome to this evening’s TechNet Event. We would like to bring your attention to the key elements of the TechNet programme; the central information and community resource for IT professionals in the UK: FREE bi-weekly technical newsletter FREE regular technical events hosted across the UK

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Welcome to this evening’s TechNet Event' - maddy


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
welcome to this evening s technet event
Welcome to this evening’s TechNet Event

We would like to bring your attention to the key elements of

the TechNet programme; the central information and

community resource for IT professionals in the UK:

  • FREE bi-weekly technical newsletter
  • FREE regular technical events hosted across the UK
  • FREE weekly UK & US led technical webcasts
  • FREE comprehensive technical web site
  • Monthly CD / DVD subscription with the latest technical tools & resources
  • FREE quarterly technical magazine

To subscribe to the newsletter or just to find out more, please visit

www.microsoft.com/uk/technet or speak to a Microsoft representative during

the break

microsoft sql server 2000 reporting services

Microsoft SQL Server 2000 Reporting Services

Melville Thomson

Parity Training

what we will cover
What we will cover:
  • Architecture
  • Creating reports
  • Importing reports
  • Publishing reports
  • Viewing reports
  • Subscriptions
prerequisite knowledge
Prerequisite Knowledge
  • Experience administering SQL Server
  • Experience administering IIS
  • Experience generating database reports
  • Familiarity with Visual Studio.NET

Level 300

agenda
Agenda
  • Architecture and Deployment
  • Creating Reports
  • Managing Reports
what is sql server reporting services
What is SQL Server Reporting Services?
  • Reporting platform for both traditional and interactive reports
  • Scalable, manageable and embeddable server infrastructure
  • Integrated with SharePoint, Office applications, browser and other familiar tools
  • Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)
sql server bi platform
SQL Server BI Platform

Reporting Services

Development Tools

Management Tools

Analysis Services

OLAP & Data Mining

Data Transformation

Services

ETL

SQL Server

Relational Engine

microsoft bi product suite
Microsoft BI Product Suite

MBS BI Applications

Excel

OWC

Map Point

Data Analyzer

OLAP addin

BSCA

SharePoint Portal

Server

Dev Tools

Visual Studio .Net

Reporting Services

Management Tools

Analysis Services

OLAP & Data Mining

Data Transformation

Services

SQL Server

Relational Engine

Windows Server

reporting services bi user profiles

SQL Server

Analysis Services

SQL Server

Reporting

Services

Reporting ServicesBI User Profiles

Analysts

5-10% of users

Information Explorers

15-25% of users

Information Consumers

65-80% of users

reporting lifecycle

Authoring

Management

Delivery

Reporting Lifecycle

Reporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.

report authoring
Report Authoring
  • Reports are defined in Report Definition Language (RDL), a documented XML schema
  • Use Microsoft or 3rd party tools that support RDL
  • Create single reports from multiple data sources(SQL, OLE DB, ODBC, Oracle, and .NET data providers)

More info on the RDL spec: www.microsoft.com/sql/reporting

report management
Report Management
  • Report definitions, folders, and resources are published and managed in a reporting web service
  • Managed reports can be executed either on-demand or via schedule and are cached for consistency and performance
  • Scalable & Extensible server architecture
report delivery
Report Delivery
  • Traditional (paper) and interactive (web) reports
  • On-demand (“pull”) or event-based (“push”) delivery
  • Choose from multiple formats (HTML, Excel, PDF, XML)
  • Deliver reports to almost any device (e-mail, file share, etc.)
architecture and deployment reporting services

Browser

Management

Custom App

Data Sources

(SQL, OLE DB, ODBC,

Oracle, Custom)

Output Formats

(HTML, Excel,

PDF, Custom)

URL

WMI

Web Service

Report Server

Report Processing

Rendering

Data Retrieval

Security

Delivery

SQL Server Catalog

Delivery Targets

(E-mail, File share,

Custom)

Architecture and DeploymentReporting Services
architecture and deployment architecture and components

Connection Management Tool

Third-Party Tools

Report Designer

Browser

Report Manager

Report Server

Request Handler

Rendering Extensions

Scheduling and Delivery Processing

Data Processing Extensions

Report Processor

Delivery Extensions

Data Source

Report Server DB

Architecture and DeploymentArchitecture and Components
architecture and deployment report processing

Data

Report Definition

Intermediate Format

On-demand Access

Scheduled or Push Access

Rendered page in HTML, PDF or other format

Layout

Snapshot or Report History

Architecture and DeploymentReport Processing
architecture and deployment reporting services client components
Architecture and DeploymentReporting Services Client Components
  • Report Designer
    • Integrated with Visual Studio.NET 2003
  • Web Browser
    • View and Manage Reports
  • Third Party Tools
    • Management
    • Authoring
    • Supported through URL, WMI or Web Services API
architecture and deployment small deployment

Server

Client

Report Manager

Report Server

Report Designer

Report Server Database

Architecture and DeploymentSmall Deployment
architecture and deployment medium deployment

Server A

Server B

Client

Report Manager

Report Server

Report Designer

Report Server Database

Architecture and DeploymentMedium Deployment
architecture and deployment large deployment

Report Server Web Farm

Clients

Report Server

Report Server

Report Server

Data Sources

SQL Server Cluster

Report Server Database

Report Server Database

Architecture and DeploymentLarge Deployment
agenda1
Agenda
  • Architecture and Deployment
  • Creating Reports
  • Managing Reports
creating reports report definition language rdl
Creating ReportsReport Definition Language (RDL)
  • Report Definition Language – XML schema contains
    • Data source information
    • Layout
    • Report Properties
  • Definitions stored in Report Server Database
  • Can create tools that use RDL
creating reports report creation process
Creating ReportsReport Creation Process
  • Connect to the data source
    • SQL Server, Analysis Services, Oracle, ODBC and OLE DB
  • Specify the query
  • Arrange the report items on the page
    • Page header, page footer and body
  • Preview the results
  • Publish the report
report items
Report Items
  • Textbox
  • Image
  • Line
  • Rectangle
  • Subreport
  • Data Regions (List, Table, Matrix, Chart)
  • Custom Report Items coming in SQL Server 2005!

$100,000

item styles
All Report Items

Background Color

Background Image

Border Color

Border Style

Border Width

Padding

Charts

Background Gradient

Textboxes

Color

Font Family

Font Size

Font Style

Font Weight

Format

Line Height

Text Align

Text Decoration

Vertical Align

Item Styles
lists
Repeating regions with freeform layout

Similar to “bands” in other report writers

But multiple lists can sit side-by-side!

Lists inside lists to get multiple levels of grouping

Use for complex repeating areas

Lists

Brian

$10,000

Jason

$20,000

Steve

$30,000

tables
Like lists with columns

Fixed columns, repeating rows

Table cells can span columns

Table cells can contain any report item

Easier to align items

Use for most reports

Tables

Person

Region

Sales

Brian

North

$10,000

Dan

North

$20,000

Total

North

$30,000

Steve

East

$50,000

Total

East

$50,000

Grand Total

$80,000

matrices
Repeats in row and column directions

Also known as pivot table or cross tab

Arbitrary formatting in headers

Different formatting for subtotals

Matrix cells can contain any report item

Use when column headings are records in your data

Matrices

Sales

2000

2001

2002

Brian

$100

$110

$120

Jason

$200

$250

$300

Steve

$300

$400

$300

Total

$600

$760

$720

charts
Data from fields in the data set

or from expressions

Full set of chart properties and types

Style enhancementsin SP1

Same data functionality as Matrix

Charts
creating reports previewing and publishing reports
Creating ReportsPreviewing and Publishing Reports
  • Debug – Preview
    • View reports in local preview window
  • Production – Publish
    • Publish reports to a production report server
slide32

demonstration

Creating Reports

welcome back to this evening s technet event
Welcome Back to this evening’s TechNet Event

We would like to bring your attention to the key elements of

the TechNet programme; the central information and

community resource for IT professionals in the UK:

  • FREE bi-weekly technical newsletter
  • FREE regular technical events hosted across the UK
  • FREE weekly UK & US led technical webcasts
  • FREE comprehensive technical web site
  • Monthly CD / DVD subscription with the latest technical tools & resources
  • FREE quarterly technical magazine

To subscribe to the newsletter or just to find out more, please visit

www.microsoft.com/uk/technet or speak to a Microsoft representative during

the break

agenda2
Agenda
  • Architecture and Deployment
  • Creating Reports
  • Managing Reports
managing reports report manager
Managing ReportsReport Manager
  • View, Search and Subscribe to Reports
  • Create and manage:
    • Folders
    • Linked reports
    • Report history
    • Schedules
    • Data source connections
    • Subscriptions
  • Set properties and report parameters
  • Manage role definitions and assignments
managing reports viewing reports
Managing ReportsViewing Reports
  • Reports can be rendered in:
    • HTML
      • HTML with Office Web Components
    • XML
    • CSV
    • Excel
    • Image – such as TIFF
    • Acrobat PDF file
managing reports report execution processing
Managing ReportsReport Execution Processing
  • On Demand
  • On Demand From Cache
    • Removed from cache at defined intervals
  • From Snapshots
    • Query is separate from render
managing reports securing the report server and reports
Managing ReportsSecuring the Report Server and Reports
  • Reporting Server Security
    • Uses IIS security
    • Windows security
  • User Permissions
    • Windows security
    • Role-based authorization
url parameter directives
URL Parameter Directives
  • Syntax
    • http://server/virtualroot? /reportpath &prefix:param
  • Report Server Parameters (rs:)

http://localhost/reportserver?/SampleReports&rs:Command=ListChildren

http://localhost/reportserver?/SampleReports/Employee+Sales+Summary&rs:Command=Render&EmpID=26

http://localhost/reportserver?/SampleReports/Product+Line+Sales&rs:Format=Excel&rs:Command=Render

  • Rendering Device Info (rc:)
    • Name/Values pairs specifying information about the format being rendered to (i.e., FindString, Section, Zoom, etc.)
    • Example find 7th page:

http://localhost/ReportServer?/SampleReports/Product+Catalog&rc:Section=7&rc:HTMLFragment=true

slide42

demonstration

Managing Reports

reporting services summary
Reporting Services Summary
  • Supports the full reporting life cycle
  • Highly scalable
  • You do not need to know RDL to create a report definition
  • Supports several data sources
  • Reports can be rendered in a variety of formats
  • Reports can be executed on demand or cached for quicker access
for more information
For More Information…
  • Microsoft SQL 2000 Reporting Services

www.microsoft.com/sql/reporting

  • Reporting Services Tech Overview

www.microsoft.com/sql/reporting/techinfo

  • Main TechNet Web site at www.microsoft.com/technet
slide45

Developer Productivity

  • .NET Framework hosting
  • Native XML technology
  • Integrated web services
  • Distributed application framework

Business Intelligence

  • Comprehensive ETL platform
  • Real time analytics
  • Accessible, easy data mining
  • Rich, integrated reporting

Enterprise Data Management

  • Flexible, manageable, scalable
  • Improved serviceability
  • Self optimization and tuning
  • Fast recovery and restore

Secure, Quality Database

  • 3 years in development
  • Multiple security reviews
  • Secure by default
  • Large private beta for early quality
ms press inside information for it professionals
MS PressInside information for IT Professionals

To find the latest titles, visit

www.microsoft.com/learning/books/

3rd party publications supplementary publications for it pros
3rd Party PublicationsSupplementary publications for IT Pros

These books can be found and purchased at all major book stores and online retailers

microsoft learning training resources for it professionals
Microsoft LearningTraining Resources for IT Professionals
  • Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
  • Course Number: 2030
    • Available Now
    • Detailed Syllabus: www.microsoft.com/learning

To locate a training provider, please accesswww.microsoft.com/learning

assess your readiness microsoft skills assessment
Assess your ReadinessMicrosoft Skills Assessment

What is Microsoft Skills Assessment?

  • Self-study learning tool to evaluate readiness for product and technology solutions, instead of job-roles (certification)
  • Windows Server 2003, Exchange Server 2003, Windows Storage Server 2003, Visual Studio .NET, Office 2003
  • Free, online, unproctored, and available to anyone
  • Answers the question: “Am I ready?”
  • Determines skills gaps and provides learning plans with Microsoft Official Curriculum courses
  • Post your High Score to see how you stack up
  • visitwww.microsoft.com/assessment
become a microsoft certified systems administrator mcsa
Become a Microsoft Certified Systems Administrator (MCSA)
  • What is the MCSA certification?
    • For IT professionals who manage and maintain networks and systems based on Microsoft Windows Server
  • How do I become an MCSA on Microsoft Windows Server 2003?
    • Pass 3 core exams
    • Pass 1 elective exam or 2 CompTIA certifications
  • Where do I get more information?

www.microsoft.com/mcsa

become a microsoft certified systems engineer mcse
Become A Microsoft Certified Systems Engineer (MCSE)
  • What is the MCSE certification?
    • Premier certification for IT pros who analyze the requirements, design, plan, and implement the infrastructure for business solutions based on the Microsoft Windows Server System
  • How do I become an MCSE on Microsoft Windows 2003?
    • Pass 6 core exams
    • Pass 1 elective exams from a comprehensive list
  • Where do I get more information?

www.microsoft.com/mcse

demonstrate your security or messaging specialization
Demonstrate Your Security or Messaging Specialization
  • What are MCSA/MCSE specializations?
    • Allows IT professionals to highlight specific expertisewithin their job role
  • Which specializations are available?
    • MCSA: Security  MCSA: Messaging
    • MCSE: Security  MCSE: Messaging
  • Where do I get more information?

www.microsoft.com/mcsaorwww.microsoft.com/mcse

what is technet
What is TechNet?
  • Put the right answers at your fingertips
    • The comprehensive collection of resources to help IT prosplan, deploy and manage Microsoft products successfully

TechNet Subscription

  • Monthly updates delivered on DVD or CD
    • The definitive resource to help you evaluate, deploy and maintain Microsoft products

TechNet Web Site

  • Accessible at www.microsoft.com/technet
    • Online resources and community
    • Subscriber-only Online Services

TechNet Flash

  • Biweekly e-newsletter
    • Security updates, new resources, and special offers

TechNet Events

and Webcasts

  • Briefings on the latest Microsoft products and technologies
    • Hands-on, “how to” information

TechNet Communities

  • User Groups
  • Managed Newsgroups
where can i get technet
Where Can I Get TechNet?
  • Visit TechNet online atwww.microsoft.com/technet
  • Register for the TechNet Flash /technet/abouttn/subscriptions/flash_register.mspx
  • Join the TechNet online forum at www.microsoft.com/technet/community
  • Become a TechNet subscriber at www.microsoft.com/technet/abouttn/Subscriptions
  • Attend more TechNet events or view onlinewww.microsoft.com/technet/community/events