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