Chat now with support
Chat with Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: REST Web Services API Appendix: SOAP-Based Web Services API Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Define Data Adapter for Stat Datasource

To connect to the Stat Repository, you need to create a new Data Adapter using JasperSoft Studio.

2
Select JDBC Connection, and click Next to open the Data Adapter Wizard.
5
Select a Driver Classpath, and click Add to add the proper JDBC driver. For example, for Oracle, the driver would be ojdbc6.jar.

Report Parameters

Jaspersoft Studio provides for several different types of Report Parameters.

Stat Predefined Global Parameters

Stat has a series of predefined global parameters. The values associated with these parameters are owned by Quest and should not be modified.

Stat Predefined (prompt) Parameters

This is a list of predefined parameters defined in Stat reports. These parameters are defined to prompt the user for a value that will filter the data on the report.

APPL_CD

CSR Application

java.lang.String

ARCHIVE_SET

Archive Set ID

java.lang.Long

ASSIGNED_USERID

CSR Assigned User

java.lang.String

CHGMGMT_FLAG

Change Management Module

java.lang.String

CLOSED_STATUS_FLAG

Closed Status

java.lang.String

CSR_ID_START

CSR ID Start

java.lang.Long

CSR_ID_END

CSR ID End

java.lang.Long

CSR_STATUS_CD

CSR Status

java.lang.String

CSR_TYPE

CSR Type

java.lang.String

CUST_ID_START

Customer ID Start

java.lang.Long

CUST_ID_END

Customer ID End

java.lang.Long

DEPARTMENT

Department

java.lang.String

DUE_DT_START

CSR Due Date Start

java.sql.Timestamp

DUE_DT_END

CSR Due Date End

java.sql.Timestamp

MIGR_CD

Migration Path

java.lang.String

OBJECT_CLASS

Object Class

java.lang.String

OBJECT_DEVELOPER

Developer

java.lang.String

OBJECT_NAME

Object Name

java.lang.String

OBJECT_TYPE

Object Type

java.lang.String

OPEN_DT_START

CSR Open Date Start

java.sql.Timestamp

OPEN_DT_END

CSR Open Date End

java.sql.Timestamp

PRIORITY_CD

Priority

java.lang.String

PROJ_CD

Project Code

java.lang.String

PS_DATABASE

Application Database

java.lang.String

MIGR_DB

Application Database

java.lang.String

QUEUE_ID

CSR Assigned Queue

java.lang.String

RECORD_STATUS

Record Status

java.lang.String

RELEASE

Release

java.lang.String

SD_CD

service domain

java.lang.String

STATISTICAL_STATUS_FLAG

Closed for Stats

java.lang.String

STATUS_CD

Status Code

java.lang.String

WRKFLW_START

Workflow ID Start

java.lang.Long

WRKFLW_END

Workflow ID End

java.lang.Long

For each predefined parameter Stat Report Wizard has a corresponding control with specific rules. It could be a dropdown for example with pre-populated list of values. Default parameter descriptions can be overridden by specifying a value in parameter description property of the report itself.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating