Chat now with support
Chat with Support

Stat 6.0 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department 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: Stat Web Services Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

stat.db.username

(optional parameter)

Stat Repository database username.

Appendix: Custom Report Files

Appendix J describes how use Jaspersoft Studio, a 3rd party reporting tool, to format the .jrxml files used to create Stat reports. It is not intended to be a comprehensive how-to guide; Instead, it points out required items and offers tips to make designing reports easier.

About Stat Report Files

All Stat reports are created with a tool called Jaspersoft Studio. This is a GUI based tool that allows you to format your report and store it in a .jrxml file. Although some knowledge of XML may be necessary to handle the finer details, Jaspersoft Studio does most of the formatting work for you. It is available at http://sourceforge.net/projects/jasperstudio/files/JaspersoftStudio-6.1.1/ at no charge. All Stat reports were created with Jaspersoft Studio 6.1.1. We suggest using the same version of Jaspersoft Studio or set the compatibility version to 6.1.1.

You may copy a Stat report that contains embedded SQL as a starting point for designing you own report. When creating a report, be aware of the following:

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.
Related Documents