+ 44 (0)1423 797 007
© 2009 JMD Consulting. All Rights Reserved
Q. How can you deliver a Business Intelligence (BI) solution to your information users that is capable of complex report authoring through a familiar Web interface whilst  retaining your existing technology investment?

A. Implementing Reporting Services® integrated into SQL Server 2005® offers a complete, server-based platform for creating, managing and delivering traditional and interactive reports.
An Integrated Architecture
SQL Server Reporting Services supports a wide range of common data sources, such as OLE DB and Open Database Connectivity (ODBC), as well as multiple output formats such as familiar Web browsers and Microsoft Office System applications. Using Microsoft Visual Studio .NET and the Microsoft .NET Framework, developers can leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats, and deliver to a variety of devices.
Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting life cycle, including:
Report authoring. We can develop reports to be published to the Report Server using Microsoft Visual Studio.  
Report management. Report definitions, folders, and resources are published and managed as a Web service. Managed reports can be executed either on demand or on a specified schedule, and are cached for consistency and performance. New in SQL Server 2005 Reporting Services, administrators can use the Management Studio to organize reports and data sources, schedule report execution and delivery, and track reporting history.
Report delivery. SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delivery of reports. Users can view reports in a Web-based format or in e-mail.  
Report security. SQL Server Reporting Services implements a flexible, role-based security model to protect reports and reporting resources. The product includes extensible interfaces for integrating other security models as well.
Key Reporting Scenarios
SQL Server Reporting Services combines a single, complete reporting platform with a scalable and extensible architecture to meet a wide variety of reporting needs, including:
Enterprise reporting. Enterprises can use Reporting Services for their operational reporting or business intelligence applications. Using Reporting Services, corporate IT staff can design a variety of reports and deploy them to individual throughout the enterprise.  
Ad-hoc reporting. SQL Server 2005 Reporting Services includes Report Builder, a new ad-hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports without deep technical understanding of the underlying data sources.  .
Web-based reporting for partners and customers. Deploy interactive Web-based reports to deliver information to customers or partners over Intranet or the Internet. Reporting Services isolates report consumers from the complexity of the underlying data sources, while providing personalisation and interactivity.

Reporting finally made easier from your financial system?

We believe so. Implementing SQL Server 2005 with Reporting Services extends your BI platform and significantly increases the return on your IT investment. We can apply our applications to any financial system, but we a proven track working with CODA Financials®.

CODA Financials® V10.1 onwards is compatible with MS SQL Server 2005, therefore allowing you to instantly start building those reports that your finance users have always wanted. All in a secure, web browser. We can build all your financial statements e.g. Profit & Loss, Balance Sheet, Aged Debt, Cash Flow etc., all with drill-down capability straight to your underlying document details and further to a scanned image of the original document.

Our Report building solution will allow for the simplification of financial statement design using our proven methodology and best practice.

Our extensible solution incorporates a secure report pack system. E.g. Batch up all of your management accounts and then print or export them as you wish with single  

Our limits with Reporting Services are only met by the limits of our imagination. Help us to see the opportunities and we will reward you with an enviable reporting solution. So, for more information please contact us now.

SQL Server 2005 for CODA
CODA Financials
Business Intelligence