Focal Point
[CLOSED] active report filtering on hyperlink

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7947064926

March 13, 2013, 04:46 PM
Kowens
[CLOSED] active report filtering on hyperlink
I opened this issue in 2011 for our 7.6.8 release, does anyone know if it has been addressed in the 8.0 version????

I have a drilldown link in my active report to another report. if I filter on this column, which I need to, the selections for the filter come up as hyperlink selections. As I choose the items for filtering, they actually drill down to the report which is annoying. Anyone know a solution to this???

This message has been edited. Last edited by: <Kathryn Henning>,


Version: 8.0.0.6
Windows platform
All output formats will probably be used.
March 14, 2013, 07:12 AM
Alex
You could put your drill down link on another column in the same record that you won't likely use for filtering.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
March 15, 2013, 05:29 AM
Trilochan
You can use any column value in a drilldown report using URL field.
 URL=abc.htm?(PARAMETER_ID=N14 DURATION=N2) 



In the page load of abc.htm use below code
 
function window_onload() {
UpdateData();
PARAMETER_IDV=getParam("PARAMETER_ID");
DURATIONV=getParam("DURATION");
window.iframe1.location.href='/ibi_apps/WFServlet?IBIF_ex=drilldownabc.fex&PARAMETER_ID='+PARAMETER_IDV+'&DURATION='+DURATIONV;
 
}

function getParam(key)
  {
  // Find the key and everything up to the ampersand delimiter
  var value=RegExp(""+key+"[^&]+").exec(window.location.search);
  // Return the unescaped value minus everything starting from the equals sign
  return unescape(!!value ? value.toString().replace(/^[^=]+/,"").replace("=","") : "");
  }
 
 

In the Iframe of iframe1 you can get the drill down data.


WebFOCUS 7.6.1
Windows, All Outputs