UKY Creating Custom Reports with Report Design Tools.pptx

1、Creating Custom Reports with Report Design Tools,This learning module describes how to create custom reports against K2 SmartObjects with K2 tools and third-party tools. It also describes how to expose and use SSRS reports as K2 SmartObjects,300.UKY Version:1 Revision:1 Duration: 1 hour to 2 hours,

2、depending on the optional topics covered, SourceCode Technology Holdings, Inc. All Rights Reserved,Module prerequisites and target audience,Target Audience Power Users with report-building experience .NET developers, System Architects Prerequisite knowledge 100.SYD K2 SmartObjects Fundamentals 200.B

3、RU K2 Workspace Reporting (optional) Prerequisite knowledge for optional topics SQL Server Reporting Services and Business Intelligence Studio (optional) Using Microsoft Excel PowerPivot (optional) Compatibility K2 blackpearl V 4.5 update 1420 or later Scope K2 custom report designer (K2 Workspace)

4、Using SmartObjects in SSRS reports Exposing SSRS reports as SmartObjects Consuming SmartObjects in PowerPivot,SmartObjects: Review,Standard K2 Workflow Reports: Review,Accessed via K2 workspace and K2 Process Portals Standard Workflow Reports Activity Statistics Process Information Process Overview

5、Process Statistics User Performance Limitations Business data is not included in the reports Report layout and style is limited to the available configuration options Cannot export the raw data for further processing,Generic Workflow Reporting SmartObjects,All the data used in the standard K2 workfl

6、ow reports is also exposed through K2 SmartObjects Use these SmartObjects to create customized reports for any workflow,Specific Workflow Reporting SmartObjects,Enable Workflow Reporting SmartObjects and select the activities/events to expose,The resulting SmartObjects,Custom Reports in K2,SmartObje

7、cts are the data source for custom K2 reports Combine data from different systems into a single report E.g. combine workflow reporting data with business data Custom Reporting Technologies K2 Workspace Report Designer Third-party designers like Visual Studio 2008 and Report Designer ADO/REST/WCF con

8、sumers e.g. Excel PowerPivot, Visio Services, SharePoint BCS UI tools (e.g. smartforms, InfoPath, ASP.NET) Consuming Reports Run custom reports in K2 Workspace Import existing SSRS reports into K2 Workspace (configuration required) Deploy custom reports to a SSRS-enabled SharePoint environment or SS

9、RS server Expose SSRS reports as K2 SmartObjects and use them anywhere,The K2 Workspace Report Designer (1/2),The K2 Workspace Report Designer (2/2),Authorized users can create Tabular, Summary or Matrix reports Any SmartObject can be used as the data source for the report You may combine data from

10、Associated SmartObjects on the same report You can optionally Summarize, Filter and Style the report Reports are saved to the category system and can be run by any user who has access to the Report Designer Can edit existing report definitions You can import reports from an existing SSRS environment

11、 (requires additional configuration),LAB 1: Creating a custom report in the K2 Workspace Report Designer,In this lab exercise you will use the custom report design tool in K2 Workspace to create a custom report.,20 minutes,Business Intelligence Studio/Report Designer (SSRS),The SourceCode ADO.NET pr

12、ovider can act as a data source for SSRS reports Developers can create custom reports by registering the SOURCECODE provider in Visual Studio 2008 Designers can use Report Designer 3.0 and reference an existing SOURCECODE data source in a SSRS environment SSRS Reports can be published to SSRS or Sha

13、rePoint or rendered in custom UIs Note: Report design tools and report servers may require additional configuration and may not be supported by K2,(Optional Topic),LAB 2: Creating a custom BI report in Visual Studio (Optional),In this lab exercise you will use Visual Studio to create a custom SSRS r

14、eport which uses SmartObject data. (This lab is optional for participants that do not use SSRS),20 minutes,Exposing SSRS reports as K2 SmartObjects,K2 provides a SmartObject broker for SSRS 2005/2008 Create a service instance for a specific SSRS server Create SmartObjects for selected reports and ex

15、ecute “Export” methods,(Optional Topic),LAB 3: Exposing and consuming a SSRS report as a SmartObject (Optional),In this lab exercise you will learn how to expose a SSRS report as a SmartObject and then use the SmartObject in a workflow.,20 minutes,(This lab is optional for participants that do not u

16、se SSRS),Consuming K2 SmartObjects in other third-party reporting applications,Excel PowerPivot SmartObject REST services can be a data source in Excel PowerPivot Can join data from multiple SmartObjects and “slice/dice” as required Save workbook locally or publish it to SharePoint Visio Services Co

17、nsume SmartObjects exposed as SharePoint lists or through a custom data source Publish Visio diagram to SharePoint SharePoint Use Business Connectivity Services to expose SmartObjects as SharePoint lists Other technologies SSIS, ADO.NET consumers, REST consumers,(Optional Topic),LAB 4: Using Excel P

18、owerPivot to create custom reports (Optional),In this lab exercise you will use the PowerPivot add-on for Microsoft Excel to create a custom report based on SmartObject data. The report will retrieve data from a SmartObject and present the data in Excel for further manipulation.,15 minutes,Workflow Reporting SmartObjects Standard Custom K2 Custom Reporting options