How Create a report with Lexical Parameter in oracle Reports

Lexical parameter is used to replace a specific ‘String’ in sql statement at runtime.

• It can be created with ‘&’ at runtime.
• String to  replace can be handled in ‘After Parameter Form’trigger.
• Used in SQL only.
• Used in all Clauses.

In this example we are going to retrieve the employees who hired in certain period of time i.e.
Step 1: Open Reports builder and connect the database, go to the data model of a new report and write a query as bellow

Press OK, system will show that ‘Query has created the lexical parameter’

Step 2: Now create report using this query. To do this right click on ‘Q_1’ and select ‘Report Wizard’ shown below









Step 3: Provide the dynamic parameter value as bellow


you can also use WHERE hirdate > ’01-Jan-2012′ OR WHERE hirdate = ’01-Jan-2012′ WHERE hirdate BETWEEN ’01-Jan-2012′ AND ’01-Jan-2013′

About these ads