Transcript web Reporting

Capita Consultancy Services &
Web Reporting
Rupert Ireland
Applications Consultant
Agenda
 SQL Server 2008 Reporting Services Examples




Drill through KPI Graphs
KPI Gauges
Matrix Reports
Reporting Services embedded in Internet Builder
 IB & MS Technology Integration
 TVU Electronic Document Management Developments
 SharePoint Upload for Internet Builder
 SharePoint Views
 New online training calendar
 Booking process
Creating Graphs in MS ReportBuilder 2
Building Expressions
Drilling down to the course level
ID Card Embedded in Columbus
Electronic Document Management
TVU
SharePoint and IB
Background
 Requirement for a secure, searchable, user friendly
online document store linked to UNIT-e
 Ability to accommodate workflows
 Users comfortable with IB and existing Columbus
pages
 Requirement to report on missing documents in
SharePoint.
 Requirement to link a single document to many
UNIT-e curriculum modules
The Solution...
 New Classes added to the database in 4.12
 SharePoint association.
 SharePoint association Item
 SharePoint Views tool
 Available in command line designer
 SharePoint Upload for Internet Builder
 Deployed with IB
Demo
SharePoint Views
Contents of SharePoint
Document Library
displayed in IB
Uploading Content
Uploading Content
SharePoint Upload
 Content Associated with a UNIT-e class
 Web search form based on standard UNIT-e
search form definition
 Multiple Associations can be created
Viewing the content in the document library
Creating a SharePoint View
 Command line Designer
Creating the view, Importing the class
Reporting on SharePoint View
Online Training Calendar
Online Booking Process
Questions