REPORT DESIGN

OVERVIEW

§ Reports are displayed of four types:

o Results of an SQL query

§ Create any select statement or stored procedure to display a Report

o Custom built ASP Pages

§ Create an ASP Report that can be linked to, this is usually used when Reports need to be formatted in a certain way

o Standard Task List Report

§ This report comes standard as part of Kontinuum and displays a number of Performance metrics graphs for each workflow

o Datacube

§ Slice and Dice Reporting tool providing advanced Reporting capability

§ To create a Report the designer must have Workflow Designer permissions

§ Click Workflow from the Admin menu

§ Navigate to the workflow that the Report relates to

§ Navigate to the Reports Folder

§ Click Add Report

Definition of Name of Report

§ The name of the Report as displayed to the end user

Definition of Parameter Form

§ This is the name of the parameter form you have created

§ Parameter forms are created in the same way as a normal data capture form, they provide added filtering and sorting capability to the Report

§ For example: if the parameter form asks a question my_id the sqlText can make use of the @@Form.my_id parameter

§ If the report is a Datacube Report then select the Parameter form as Datacube

Definition of SQL Text

§ If the Report is an SQL Report this field is required

§ WAFFL parameters can be used in this field

§ For example: To return all results for a particular user the SQL text would be: [select * from mytable where username = ‘@@User.Username’]

Definition of Go to Page

§ If the report is an ASP Page enter the location of the page

§ Note: If there is a parameter form for this ASP Page then the parameters are passed along in the query string to this page

Definition of Report User Types

§ Add all the user types that are allowed to view this report

§ This field is required