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.
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′
No comments:
Post a Comment