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 14 changed 2 lines
;Step 1:Create a new function for this report.\\ \\Any report run from within [{$applicationname}] must be defined as a function in the [IMFN] screen. The first two reports will be retrieving data from the HR tables only and is similar to the [RENA] report.\\ \\
;Step 2:Enter [REBR] for the function name and add a description for this report.\\ \\This demonstration will create a report named [REBR]. This follows our standard report naming convention. The 'R' indicates a read only report. This will not make any changes to existing data within the database. 'E' represents it is a member of the HR (employee) module, and 'BR' is an abbreviation for a Birthday Report.\\ \\Since this report is displaying employee information only, it should be part of the HR product group.\\ \\
;Step 1:Create a new function for this report.\\ \\Any report run from within [{$applicationname}] must be defined as a function in the [IMFN] screen. The first two reports will be retrieving data from the HR tables only and is similar to the RENA report.\\ \\
;Step 2:Enter REBR for the function name and add a description for this report.\\ \\This demonstration will create a report named REBR. This follows our standard report naming convention. The 'R' indicates a read only report. This will not make any changes to existing data within the database. 'E' represents it is a member of the HR (employee) module, and 'BR' is an abbreviation for a Birthday Report.\\ \\Since this report is displaying employee information only, it should be part of the HR product group.\\ \\
At line 87 changed one line
;Step 2:In [{$applicationname}], run the [REBR] report by typing the command into the command window.
;Step 2:In [{$applicationname}], run the REBR report by typing the command into the command window.
At line 101 changed one line
;Step 4:Select [REBR] as the function name opening the [IMPM] screen.\\ \\Since this is a new report there will be no parameters listed in the screen initially. Pressing the green plus icon will cause a new parameter to be created named P_MONTH with:
;Step 4:Select REBR as the function name opening the [IMPM] screen.\\ \\Since this is a new report there will be no parameters listed in the screen initially. Pressing the green plus icon will cause a new parameter to be created named P_MONTH with:
At line 107 changed one line
;Step 5:Open [IMFDH] and edit the Form Layout tab of the [REBR] function.\\ \\[Training.Create_Winward_Report_04.jpg]\\ \\This will require the user to manually key in the two digit month in order to run the report. By making a simple change to the parameter defined in [IMPM], a lexicon list can be offered to the user to select the month or months to report.
;Step 5:Open [IMFDH] and edit the Form Layout tab of the REBR function.\\ \\[Training.Create_Winward_Report_04.jpg]\\ \\This will require the user to manually key in the two digit month in order to run the report. By making a simple change to the parameter defined in [IMPM], a lexicon list can be offered to the user to select the month or months to report.
At line 110 changed one line
In [IMPM], for the P_MONTH parameter of [REBR], replace the VARCHAR2 in the Reference column with [X_REG_EMPLOYMENT_DATE].\\ \\
In [IMPM], for the P_MONTH parameter of REBR, replace the VARCHAR2 in the Reference column with [X_REG_EMPLOYMENT_DATE].\\ \\
This page (revision-22) was last changed on 26-Nov-2021 10:22 by kparrottTop