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

Need to have hyperlink to a new report after the drill down.

If the situation occurs where you need to have hyperlink to a new report after the drill down. Then our suggestion is to make a report with value interaction to another report which shows the earlier column1 and drill column2.  This appears as its drilling down. And give value interaction to the third report detailed report.

This is a First Report

This is a Second Report when you click on ‘Type 1’

This is a Third Detailed Report when you click on ‘Status 1’