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

Watermarks

You may add a watermark to your reports. Watermarks display on the right side of the report. The text runs from bottom to top. All reports will have the same watermark.

1
Locate the file <Stat_home>/report/report.properties where is Stat Central Agent is installed.
2
Open the file.
3
Locate the statement: #BACKGROUND_TEXT=For internal use only.
4
Remove the #.
5
Modify the right side of the equation as desired.
6
Save and close the file.
7
Re-start the Stat Central Agent to enable file modifications.

Copyright

Reports delivered by Quest are copyrighted by Quest. If you copy a Quest report it will reflect the Quest Copyright.

To add your own copyright to your custom report. There are two methods to handle this.

1
Remove the parameter $P{CompanyReserve} from the bottom of the report
2
Add a static field that includes your copyright information. This static text field must be defined on each report, but can be a different value on each report if desired.
3
Alternatively, define your own custom global parameter. This allows you to place the same information on several reports and modify it in a single location.
The naming convention is P_X where X is whatever you wish. Parameter class should be <java.lang.String>.
a
Place the parameter in the appropriate location on the report
b
Open <STAT_HOME>/report/report.properties and define the parameter at the end of this file under the global parameters comment.
Example P_Company=(c)2011 MyCompany
c
Re-start the Stat Central Agent to enable file modifications

Report Variables

Jaspersoft Studio also has a series of predefined variables that allow you add information to your reports. For example: PAGE_COUNT AND PAGE_NUMBER allow you to specify page 3 of 10 on your page. These variables may be viewed in the Variables section of the Report Inspector.

Text Field Expressions

Sometimes you may wish to reformat the data coming from the database. For example, a check box on is stored as a 1 and off is stored as a 0. You may wish to format this on the report to on/off or yes/no. This is done in the Text Field Expressions box. Click on the ellipsis to expand the field and add you formatting. Some examples are listed below.

•
Date time
""+(new SimpleDateFormat("ddMMMyyyy HH:mm")).format(new java.sql.Date($P{CurrentTime}.getTime()))
•
Simple if statement when the value may be null
$F{APPL_CD}==null?"All":$F{APPL_CD}
If APPL_CD is null then print All, otherwise print the actual APPL_CD value.
•
Simple if statement
(( $F{OA_VERSION_ID}.equals("1"))?"11i" : "R12")
If OA_VERSION_ID = 1 the print 11i, otherwise print R12
•
If statement with 5 options
(( $F{OA_CUSTOM}.equals("B"))?"Custom with Lang" : ( ( $F{OA_CUSTOM}.equals("P"))?"Custom w/o Lang":( $F{OA_CUSTOM}.equals("Y"))?"Generic":( $F{CUSTOM_TYPE}.equals("N"))?"Predefined":"Unk") )
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione