Chatta subito con l'assistenza
Chat con il supporto

Stat 7.0 - 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 Enabling Web Client to perform PeopleSoft migrations 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: Oracle Agent: Stat.conf and log4j2.xml configuration Appendix: Custom Report Files

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:

•
You must give the report file a new unique name
•
You must change the name inside the .jrxml file to reflect the new name
•
You are not allowed to edit the existing files in their current locations. These files are the property of Quest Software and will be overlaid with each release of Stat.
•
Once the report has been created, use the maintenance tool to upload your .jrxml file into the Stat Central Agent repository. For more information, see Stat Report Definition Maintenance .
•
The tool adds the report to the STAT_REPORT_DEFN table and will insert the file into <STAT_HOME>/report/custom on the agent server
•
It is recommended that you archive your custom files into your Stat repository and/or backup the <STAT_HOME>/report/custom folder on a regular basis.

Define Data Adapter for Stat Datasource

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

To create a new Data Adapter:
1
In JasperSoft Studio, navigate to the Repository Explorer and create a new adapter.
2
Select JDBC Connection, and click Next to open the Data Adapter Wizard.
3
Specify the JDBC driver. For example, if the Stat Repository is on Oracle, select oracle.jdbc.driver.OracleDriver.
4
Enter a valid JDBC URL, user name, and password.
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.

•
Parameters provided by Jaspersoft Studio for internal workings of the report start with REPORT_, JASPER_REPORT, plus a couple others all in capital letters.
•
Stat supplies a few global parameters that may be used to populate data on your report. This includes the date/time that the report was created, the Report Title as stored in the Report Library and a Watermark on the report
•
Stat Reports use a series of prompt parameters that may be used in your custom reports. They can be used to filter data on your reports.
•
You may define your own custom parameters that prompt for data. Their names must be different than the predefined list below.
•
You may also define custom global parameters. These must start with P_. These may be used in combination or as replacements for the Stat delivered global parameters.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione