SQL Reporting Services

1
(No Transcript)
2
SQL Reporting Services

• Deliver real-time information
• to support daily operations
• and drive decisions.
• Andy Smith
• Application Consultant CPiO

3
SQL Reporting Services

• Agenda
• What is SQL Reporting Services?
• Demonstration of some simple drill through
  reports
• Demonstration of Report Delivery and Scheduling
• Demonstration of SRS Report Builder
• How SQL Reporting can help your Business
• Q A

4
What is SQL Reporting Services?

• According to Microsoft

SQL Server Reporting Services is a comprehensive,
server-based solution that enables the
creation,management, and delivery of both
traditional, paper-oriented reports and
interactive, Web-based reports. An integrated
part of the Microsoft Business Intelligence
framework, Reporting Services combines the data
management capabilities of SQL Server and
Microsoft Windows Server with familiar and
powerful Microsoft Office System applications to
deliver real-time information to support daily
operations and drive decisions.
5
What is SQL Reporting Services?

• According to CPiO Marketing SQL Server
  Reporting services provides access to real time
  information to support daily operations and
  drive decisions.

• According to Me
• SRS is a FREE tool providing Martini access to
  your data.
• Any time , Any Place, Anywhere thats
  Martini.....

(Subliminal message In your mind replace
Martini with SQL Reporting Services)
6
Demonstration of some simple drill through
reports
7
Demonstration of Report Delivery and Scheduling
8
Demonstration of SRS Report Builder
9
How SQL Reportingcan help your Business

• Business information designed how you want it,
  not limited to traditional standard reports.
• Let decision makers have access to data when and
  where they want it.
• Utilise existing investment in SQL server
  licenses.
• Ability to access data from different sources and
  display the information in a single report. Not
  limited to Sage, Axapta, MSCRM can access any
  ODBC compliant database.
• Rapid Delivery of reports. Many customers have
  replaced their existing Crystal/Cognos/Access
  Reports with SRS.

10
How SQL Reportingcan help your Business

• Secure (Access controlled by Active directory),
  centralised reporting deployed via a website
  that can be embedded into other applications or
  left to run standalone.
• Ability to schedule real time reports delivered
  via email or File share in a choice of formats
  (web, Excel, PDF, CSV) to recipients (Internal
  and External). 
• Standardised reports across many Operating
  Companies,1 report can be used to report on
  individual or Consolidated Operating Companies.
• Ability to drill into headline information to see
  information grouped in required format, or to
  drill into individual transaction lines.

11
Examples delivered already

• Standardised reporting platform for Business with
  Operations across EMEA
• Identify in-active Customers
• Identify Customers who are taking longer to pay
  their bills
• Provide instant Management team summary
  information
• Review Opportunity and Sales order information in
  a single report

12
Examples delivered already

• Analyse stock values, and checking stocking
  levelsfor Bills of Materials
• Provide Purchase order recommendations(no need
  to buy MRP!)
• Analyse Nominal Ledger values and transactions
• Extract data automatically to be used by other
  systems
• Creation of Mailing letters, based on different
  criteria

13
Any Questions?