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 97 added one line
At line 98 removed 4 lines
Open the function definition and add P2K_HR_ASSIGNMENT_DETAILS to the subject table field.
Save this change and immediately add a new record to the IMLQ screen.
Once a subject table has been specified in IMFN, an entry in IMLQ is required for the report to run. Attempting to run the report now will result in the report parameter screen hanging at 'preparing report data'.
In IMLQ, edit the automatically generated list of values for IMPV_REBR. Any report defined in IMFN that contains a subject table value will have an entry in IMLQ named IMPV_<function name>. An example that could be used for our report is listed in the IMPV_RENA entry:
At line 103 changed 13 lines
All entries in the IMLQ screen must select five and only five columns from the database. The select statement must be in uppercase and the fifth column must return the ID of the subject table. Other than these restrictions the select statement can be as simple or compli¬cated as needed to restrict the records to a known set. As can be seen in this statement, the table or view that is being used does not need to be the subject table at all. The fifth col¬umn in this statement is using the EASD_ID from the VSASSIGNMENTS view to build the report list. The current prime assignments will be the only records added to the report list due to the 'where' clause.
In the IMPM screen, a new parameter can now be defined for this report.
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:
Prompt of ‘Month’
Reference of ‘VARCHAR2’
Data type of ‘Varchar2’
Parameter length of ‘2’
Turning on the Filter checkmark indicates to ePersonality that this parameter will modify the SELECT statement in IMLQ. With this checkmark turned on, a Validation Clause is required in the CLAUSE tab of the IMPM record.
TO_CHAR(BIRTH_DATE, 'MM') IN (<LIST>)
Adding the code segment shown above will allow the user to enter one of more, 2 character months as a qualifier for the report list.
The final step is to add this parameter to the report parameter definition within the IMFDH screen.
Open IMFDH and edit the Form Layout tab of the REBR function.
#Open the function definition and add P2K_HR_ASSIGNMENT_DETAILS to the subject table field.\\ \\#Save this change and immediately add a new record to the IMLQ screen.\\ \\Once a subject table has been specified in IMFN, an entry in IMLQ is required for the report to run. Attempting to run the report now will result in the report parameter screen hanging at 'preparing report data'. \\ \\
#In IMLQ, edit the automatically generated list of values for IMPV_REBR. Any report defined in IMFN that contains a subject table value will have an entry in IMLQ named IMPV_<function name>. An example that could be used for our report is listed in the IMPV_RENA entry:\\ \\[Training.Create_Winward_Report_03.jpg]\\ \\
All entries in the IMLQ screen must select five and only five columns from the database. The select statement must be in uppercase and the fifth column must return the ID of the subject table. Other than these restrictions the select statement can be as simple or compli¬cated as needed to restrict the records to a known set. As can be seen in this statement, the table or view that is being used does not need to be the subject table at all. The fifth col¬umn in this statement is using the EASD_ID from the VSASSIGNMENTS view to build the report list. The current prime assignments will be the only records added to the report list due to the 'where' clause.\\ \\In the IMPM screen, a new parameter can now be defined for this report.\\ \\
#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:
#*Prompt of ‘Month’
#*Reference of ‘VARCHAR2’
#*Data type of ‘Varchar2’
#*Parameter length of ‘2’ \\ \\Turning on the Filter checkmark indicates to ePersonality that this parameter will modify the SELECT statement in IMLQ. With this checkmark turned on, a Validation Clause is required in the CLAUSE tab of the IMPM record.\\ \\
TO_CHAR(BIRTH_DATE, 'MM') IN (<LIST>)\\ \\
Adding the code segment shown above will allow the user to enter one of more, 2 character months as a qualifier for the report list. \\ \\
The final step is to add this parameter to the report parameter definition within the IMFDH screen.\\ \\
#Open IMFDH and edit the Form Layout tab of the REBR function.
This page (revision-22) was last changed on 26-Nov-2021 10:22 by kparrottTop