Scorecard Report - SQL Server Reporting Services (SSRS)
Business Situation
To be successful in today's competitive marketplace, organizations need to extend information beyond the walls of their organization and seamlessly interact with customers, partners, and suppliers in real time. Microsoft SQL Server Reporting Services enables organizations to transform valuable enterprise data into shared information for insightful, timely decisions at a lower Total Cost of Cwnership (TOC).
Solution
SQL Server 2005 Reporting Services extends the Microsoft Business Intelligence (BI) platform to reach the executive management and information worker who needs access to business data. Reporting Services is a server-based enterprise reporting environment, managed via web services. Reports can be delivered in a variety of formats, with a range of interactivity and printing options. Complex analyses can reach a broad audience through the distribution of reports as a data source for downstream business intelligence.
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.
Business Benefits
Reporting Services combines a single,complete reporting platform with a scalable and extensible architecture to meet a wide variety of reporting needs:
- Enterprise reporting.
- Ad Hoc reporting.
- Embedded reporting.
- A complete, server-based platform for reporting.
- Flexible and extensible reporting.
Report users can upload and view each report separately; however, some reports are designed to work together through the use of links. You can design and create reports as templates for designing new reports.
Report users can post reports to a portal, email them to users, or allow users to use the web-based report server to access reports from a folder hierarchy. Navigation, search, and subscription features help users locate and run the reports they need. Personalized subscriptions let them select the rendering format they prefer.
VTL Consulting provides technical solutions, report and data warehouse design, and implementation that turn your data into reports (Balance Sheet, Income Statement CurYTD- Company, Income Statement YTD-Region, Income Statement Trended, Trial Balance Variance Report) using Microsoft SQL Server Reporting Services tools that would consolidate data and provide commitment reporting and goal collection in an integrated web application using Microsoft SharePoint Portal Server without requiring programming and customization:
Some of the best resources for SQL Server Reporting Services (SRS) are found on Microsoft's own sites, the only problem is knowing where to find them.
Information about Versions and Editions of SRS:
Introductions and Overview articles on the web about SRS:
Information about SRS Setup and Administration. (setup and administration)
Useful articles
Information about the SRS Report Builder - a powerful tool that lets non-techies slice and dice SRS data.
How to videos from MSDN TV - Channel 9
Keep tabs on the latest SRS developments by staying on top of SRS team blogs.
Links to other SRS resources: