Wednesday 6 July 2011

To Display the Report for the current Year using Advanced SQL Filter.

Create an initialization block for the dynamic variable.
For Ex-Here it is Current_Year_Sample

Query - select to_char(max(sysdate),'YYYY') from dual
Provide the name of the dynamic variable and assign a default value.


In the answers

Click in the filter on Year column
Click on the ‘Convert this filter to SQL’
Write the following

Column_Name = VALUEOF("Current_Year_Sample"."Current_Year_Var_Sample")

Result



No comments:

Post a Comment

Thanks to Comment
--Add--