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



Tuesday 5 July 2011

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’