This page (revision-22) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
22 26-Nov-2021 10:22 26 KB kparrott to previous
21 26-Nov-2021 10:22 26 KB kparrott to previous | to last

Page References

Incoming links Outgoing links
Training.Create_Winward_Report...nobody
Training.Create_Winward_Report

Version management

Difference between version and

At line 3 changed 2 lines
!!CREATING A NEW WINDWARD REPORT
!Objectives
!!!CREATING A NEW WINDWARD REPORT
!!Objectives
At line 12 changed one line
!!CREATING A BIRTHDAY REPORT
!!Creating a Birthday Report
At line 23 added one line
At line 24 changed 12 lines
After the function has been defined in IMFN, go to the IMFDH screen. This screen defines the report parameter screen layout as well as all the tables the report needs access to.
Table Usage Tab
Under the Table Usage tab:
Add P2K_AM_EXECUTIONS in the Data Source field and set the Where Clause field to ‘NEW MEX ID ONLY’
Add P2K_HR_ASSIGNMENT_DETAILS in the Data Source field
Set the Table Usage field to ‘User Defined’ for both of these tables.
If you are creating a report that is accessing the same table twice for different information the Table Alias and Join Clause fields are required for the second occurrence of the table.
Form Layout Tab
Since we will be adding parameters to the report at a later time, we can ignore the Form Layout tab. This tab is used to define what parameters and filters are presented to the user and where they appear when the report is launched.
Menu/Drill Downs Tab
The Menu/Drill Downs tab will be used later to add our report to the HR menu. During development and testing of the report we will simply run the report from the command win¬dows within EP.
Report Template
After the function has been defined in [IMFN], go to the [IMFDH] screen. This screen defines the report parameter screen layout as well as all the tables the report needs access to.
;Table Usage tab:
#Add P2K_AM_EXECUTIONS in the Data Source field and set the Where Clause field to ‘NEW MEX ID ONLY’
#Add P2K_HR_ASSIGNMENT_DETAILS in the Data Source field
#Set the Table Usage field to ‘User Defined’ for both of these tables.
#If you are creating a report that is accessing the same table twice for different information the Table Alias and Join Clause fields are required for the second occurrence of the table.
;Form Layout tab:Since we will be adding parameters to the report at a later time, we can ignore the Form Layout tab. This tab is used to define what parameters and filters are presented to the user and where they appear when the report is launched.
;Menu/Drill Downs tab:The Menu/Drill Downs tab will be used later to add our report to the HR menu. During development and testing of the report we will simply run the report from the command windows within EP.
!Report Template
At line 37 changed one line
Open MS Word and create a new Rich Text Format [RTF] document named REBR.rtf. This file is case sensitive; the file name must be in uppercase while the extension must be lowercase.
*Open MS Word and create a new Rich Text Format [RTF] document named REBR.rtf. This file is case sensitive; the file name must be in uppercase while the extension must be lowercase.
At line 39 changed 5 lines
Create a title for the new report and insert a table to format the column headings and data of the report. The table only needs to contain three rows with five col¬umns each. Our report will contain the employee name, person code, gender, birth date and age. The entire second row will be blank to provide space between these headings and the data.
Once the basic report layout has been created, define its XML structure using the Data/Data Sources of the Auto Tag menu. This report data source will need to be added as XML (file or URL) with the following URL:
http://argo.highlinecorp.com/selfService_AS01/reportdatastructure?NAME=REBR
NOTE:
This is an example using the AS01 instance in High Line's ARGO application server. The application server and instance name will need to be changed to point to a local environment.
*Create a title for the new report and insert a table to format the column headings and data of the report. The table only needs to contain three rows with five columns each. Our report will contain the employee name, person code, gender, birth date and age. The entire second row will be blank to provide space between these headings and the data.
Once the basic report layout has been created, define its XML structure using the Data/Data Sources of the Auto Tag menu. This report data source will need to be added as XML (file or URL) with the following URL:\\[http://argo.highlinecorp.com/selfService_AS01/reportdatastructure?NAME=REBR]
%%information This is an example using the AS01 instance in High Line's ARGO application server. The application server and instance name will need to be changed to point to a local environment.%%
At line 47 added one line
At line 46 changed 5 lines
P2K_AM_EXECUTIONS [MEX]
P2K_AM_EXECUTION_RUN_LOGS [MRL]
P2K_AM_USERS [MUS]
P2K_AM_FUNCTIONS [MFN]
P2K_AM_SITES [MST]
*[P2K_AM_EXECUTIONS] (MEX)
*[P2K_AM_EXECUTION_RUN_LOGS] (MRL)
*[P2K_AM_USERS (MUS)
*[P2K_AM_FUNCTIONS (MFN)
*[P2K_AM_SITES (MST)
At line 56 added one line
At line 58 added one line
At line 60 added one line
At line 62 added one line
This page (revision-22) was last changed on 26-Nov-2021 10:22 by kparrottTop