title: Oracle APEX Interactive Report Column with Hyperlinks to different page using a Case Statement
body: <p>I am trying to utilize an APEX Interactive Report and have a hyperlink to different page in the app based on the result of a case statement.  I am guessing I am not formatting the href correctly here.  Any help is greatly appreciated. In this example, when 'section' = 'Confirm the Project' I want the user to be able to click in the column for that row and it will take them to page 2. </p>
  
  <p>Thanks,</p>
  
  <pre><code>select
  section,
  status,
  case when section = 'Confirm The Project' then 
  ('&lt;a href="'|| sys.htf.escape_sc('f?
  p='||:APP_ID||':2:'||:APP_SESSION||':::2,RIR:IR_Status:Active:') ||'"&gt;')     else null end as Link
  from 
  crd_trans_final_view
  </code></pre>