Important Points for Oracle standard Reports

Important Points for Oracle standard Reports

Following are the points that are mandatory every time when we edit or create report in Oracle standard Report. 

1. For a sql query having parameter and binding variables, the parameters will be added automatically on the "USER PARAMETERS" on the left side of Object navigator window. 

     If date parameter is used then right click on the date parameter, go to -> Property inspector. 

     Change the 'Input Mask' to any desired input value. And change the 'Datatype' -> Date.

2. Click the '+' button (green button) and add a parameter with naming as .P_CONC_REQUEST_ID'.

3. Edit the 'Before trigger' and 'After Trigger' option.