Our Specialties
To be successful in today's competitive marketplace, organizations need to extend information outside their organization and interact with customers, partners, and suppliers. We can enable your organization to transform your valuable data into shared information for up to date decision making. We’re experts at Reporting Services implementation, report development, and support.

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. When integrated with PerformancePoint Dashboard Designer, more robust Business Intelligence solutions can be implemented, giving your business the insight needed for that competitive edge.

Report Design
• Basic Report Design with table reports
• Creating drill down, document maps and actions
• Using expressions, multi-value report parameters, interactive sorting and floating headers
• Using the Tablix to create table, matrix and lists
• Subreports and Charting
• Building parameterized reports using query parameters and filters
• Using stored procedures and user defined functions to build dynamic reports
• Displaying recursive hierarchies
• Creating reports from an Analysis Services cubes

Business Intelligence Reporting
• Reporting with Analysis Service
• Dashboard development, including KPI's, scorecards and SQL Server Reporting Services charts and reports

Ad-Hoc Reporting
To extend the reach of Reporting Services within organizations, SQL Server 2005 and 2008 Reporting Services includes Report Builder, an ad-hoc reporting tool that allows business users to create their own reports and explore corporate data. Report Builder’s user-friendly business query model lets end users build reports without a deep technical understanding of the underlying data sources. It’s literally a “click and drag” tool that most anyone can use. These reports can then either be saved to a user’s personal folder or to a shared folder for extended and repeated use.

Administering Reporting Services

• Report Management
• Publishing content to report server for public consumption
• Organizing content into folders
• Configuring data settings
• Setting up report execution (on demand, cached instanced and snapshots)
• Delivering reports via standard and data driven subscriptions
• Administering and monitoring report executions and subscriptions
• Manipulating the server configuration files
• Report server administration

2801 Stanbridge Street
Suite A415
East Norriton, PA 19401
NIKA Enterprise, LLC
Consulting Services