K2 for SQL Server Reporting Services

For an example of using the SQL Server Reporting Services Service Broker, see the topic Reporting Services Service scenario in the K2 blackpearl User guide

K2 reporting tools give anyone the power to create and execute reports that meet individual needs and preferences and are based on corporate information and appropriate level of security. Common business entities are surfaced to report builders so they can access all necessary data without the need to recall where it is stored. Users can build reports for personal use or to share with others in the organization. K2 reports leverage the Microsoft Windows SQL Server 2008 or later Reporting Services platform for storing and rendering reports. This allows any Reporting Services-compatible tool, such as Business Intelligence Studio, to create and access the Report Definition Language (RDL) generated reports.

Reports can be created and rendered locally using the K2 Report Designer without SQL Reporting Services. However, it is highly recommended that SQL Reporting Services is utilized for maximum reporting capabilities, including access to out-of-the-box reports and sharing custom reports.

The K2 for Reporting Services component can be installed on an existing Reporting Services environment, but does require Microsoft SQL Server 2008 or greater.

There are two ways K2 integrates with SSRS allowing you to import SSRS reports or build SSRS reports:

1. Using the K2 Data Provider registered in SSRS.
2. By creating a service instance.

For more information on Reporting, see the topic Reporting in the K2 blackpearl User Guide.