Reporting Magic

Reporting Magic is an enhanced Management Information System for use with the BMC Magic Service Desk Suite / Service Desk Express. Based on Microsoft SQL Reporting Services, Reporting Magic offers a genuine alternative to the Crystal Reports package that is bundled with the Magic Service Desk Suite / Service Desk Express.

Reporting Magic will provide, out-of-the-box, a replacement for every one of the standard 121 reports with Magic Service Desk Suite 8.0.

Functionality
Reporting Magic will provide all of the functionality detailed below and more…

Multiple Data Sources On One Report
Microsoft SQL Reporting Services allows a report to be built from any number of data sources. This includes non Microsoft based data sources e.g. Peoplesoft on Oracle.

Enhanced Security
Microsoft SQL Reporting Services allows security to be set at a folder or even individual report level. Users who don’t have access to these reports don’t even see them!

Scheduled Reports
Microsoft SQL Reporting Services allows subscriptions to be created and reports sent to users via email.

High Scalability and Low Cost
Microsoft SQL Reporting Services provides a completely web based (zero-client installation) reporting solution thats only licensing requirement is that you have a licensed copy of Microsoft SQL Server 2000.

Increased Performance/Availability
Microsoft SQL Reporting Services allows the use of either T-SQL or Stored Procedures – it is your choice. Microsoft SQL Reporting Services uses Data Source files to tell the report which server/database to call. These can be specific to the report or shared across any number of reports. Using this Data Source technology your Management Information System can be immediately re-pointed at a new server/database in the event of disaster – all via a web interface.

Ease of Deployment/Maintenance
Microsoft SQL Reporting Services allows deployment either via Microsoft Visual Studio or via a simple web interface. Microsoft SQL Reporting Services allows any testing area to be hidden and then reports moved, either on mass or individually, from one area to another – all via a web interface.

Plus…
Reporting Magic provides a complete set of client driven reports. These reports can be made available from self-service allowing either all or a selection of clients to run their own reports with no additional cost. These reports include My Incidents, My Work Orders, My Purchases, My Assets, and My Summary (the client’s details and a summary of the above.)

Images:

Incidents Closed Urgency Not Met By Week

Incidents Daily FCR

Downloads:

> Magic V8 Reports for use with Visual Studio 2003 and SQL Reporting Services 2000

> Magic V8 Reports for use with Visual Studio 2005 and SQL Reporting Services 2005

System Requirements:
Whilst the reports replace the Magic Service Desk Suite 8.0 Crystal Reports, they will work with both Magic Service Desk Suite 8.0 and Service Desk Express 9.0 and above. You need to download the correct version of the reports for the version of Microsoft SQL Reporting Services you are running. The version of your database server is not important.

Installation:
Unzip the files to any location on your workstation. Upload them to your SQL Reporting Services installation.

Database Access:
Reporting Magic needs to have read only access to the SDE database. You may either use an existing SQL server account or create a new one for the reports (recommended) – ONLY requires dbreader (read) access.

Copyright:
The only Copyright on these reports is that you don’t charge for them. These reports are provided free of charge and you are free to make as many changes as you like. All I ask is that you don’t take any credit for what you haven’t done! It is as simple as that.

Support:
For support either email me directly (alan@14j.co.uk).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s