[SOLVED] Drill down - Multiple Requests

August 26, 2017, 04:23 PM

Enigma006

Hello

I would like to have drill down on 1 field's data and have multiple requests to run.

 
TABLE FILE COUNTRY
BY COUNTRY
END

As an example, when clicked on country data, I want to open google.com in 1 window, yahoo.com, in 1 window and run 1 report for clicked country in one iframe.
Is this possible? I am aware of adding multiple drill menu items but this is different I believe. One click to run multiple requests.
Please suggest.

Thank you.

This message has been edited. Last edited by: FP Mod Chuck,

August 27, 2017, 05:25 PM

David Briars

You might want to try using the JAVASCRIPT StyleSheet attribute, to open n windows from one WebFOCUS HTML report link..

-*
-* Create Main Report.
-*
TABLE FILE CAR
"Main Report"
SUM SALES/D9C
BY COUNTRY
ON TABLE HOLD AS HLDMNRPT FORMAT HTMTABLE
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLESHEET *
 INCLUDE = ENInformationBuilders_Light1, $ 
 TYPE=TITLE,  JUSTIFY=CENTER, $
 TYPE=DATA, COLUMN=COUNTRY, JAVASCRIPT=fn_drilldown(COUNTRY), COLOR=BLUE,$
ENDSTYLE
END
-RUN
-*
-* Report Presentation.
-*
-HTMLFORM BEGIN NOEVAL
<!DOCTYPE html>
<head>
<TITLE>Main Report</TITLE>
<script language='javascript'>
// Set window properties.
   var WProps1 = new String("location=no,toolbar=no,directories=no");
       WProps1 += ",scrollbars=yes,menubar=no";
       WProps1 += ",status=no,resizable=yes,top=100,left=10,width=300, height=580";
   var WProps2 = new String("location=no,toolbar=no,directories=no");
       WProps2 += ",scrollbars=yes,menubar=no";
       WProps2 += ",status=no,resizable=yes,top=100,left=500,width=500, height=580";
 //
 // Function: fn_drilldown
 // Purpose : Call Drill Down Report.
 //
  function fn_drilldown(country) {
   // Create a random number.
   var rand = 0;
       rand = Math.round(Math.random() * 100000);
   drilldownurl = '/ibi_apps/WFServlet?IBIAPP_app=mashups&IBIF_ex=drilldownreport.fex&COUNTRY=' + country + '&RND=' + rand.toString();
   // Open the detail report in a new window.     
    window.open(drilldownurl, "", WProps1);
   // Open FocalPoint in a new window.  
    window.open("https://forums.informationbuilders.com/eve/forums/a/frm/f/7971057331","", WProps2);
  }
</SCRIPT>
</HEAD>
<BODY>
 !IBI.FIL.HLDMNRPT;
</BODY>
</HTML>
-HTMLFORM END

 -* File drilldownreport.fex
TABLE FILE CAR
"Drill Down Report"
"Country => &COUNTRY"
SUM SALES/D9C
BY  CAR
BY  MODEL
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
 INCLUDE = ENInformationBuilders_Light1, $
 TYPE=REPORT, TITLETEXT='Drill Down Report',$
 TYPE=TITLE,  JUSTIFY=CENTER,$
ENDSTYLE
END

September 05, 2017, 08:20 PM

Enigma006

David, this worked for me when running independently. But my main report will run on a parameter driven HTML page.
Parameter names are START_DATE, END_DATE and TRACK. So, I changed the code to this.

 TYPE=DATA, COLUMN=N1, JAVASCRIPT=fn_drilldown(&START_DATE &END_DATE &TRACK),

 function fn_drilldown(start_date,end_date,track)
 {
chart_url = '/ibi_apps/WFServlet?IBIF_ex=IBFS:/WFC/Repository/AA/mainreport.fex&|START_DATE=' + start_date + '&|END_DATE=' + end_date + '&|TRACK=' + track;
alert(chart_url); 
}

But parameters are not being passed. Am I doing something wrong?

Please suggest.

quote:

Originally posted by David Briars:
You might want to try using the JAVASCRIPT StyleSheet attribute, to open n windows from one WebFOCUS HTML report link..

-*
-* Create Main Report.
-*
TABLE FILE CAR
"Main Report"
SUM SALES/D9C
BY COUNTRY
ON TABLE HOLD AS HLDMNRPT FORMAT HTMTABLE
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLESHEET *
 INCLUDE = ENInformationBuilders_Light1, $ 
 TYPE=TITLE,  JUSTIFY=CENTER, $
 TYPE=DATA, COLUMN=COUNTRY, JAVASCRIPT=fn_drilldown(COUNTRY), COLOR=BLUE,$
ENDSTYLE
END
-RUN
-*
-* Report Presentation.
-*
-HTMLFORM BEGIN NOEVAL
<!DOCTYPE html>
<head>
<TITLE>Main Report</TITLE>
<script language='javascript'>
// Set window properties.
   var WProps1 = new String("location=no,toolbar=no,directories=no");
       WProps1 += ",scrollbars=yes,menubar=no";
       WProps1 += ",status=no,resizable=yes,top=100,left=10,width=300, height=580";
   var WProps2 = new String("location=no,toolbar=no,directories=no");
       WProps2 += ",scrollbars=yes,menubar=no";
       WProps2 += ",status=no,resizable=yes,top=100,left=500,width=500, height=580";
 //
 // Function: fn_drilldown
 // Purpose : Call Drill Down Report.
 //
  function fn_drilldown(country) {
   // Create a random number.
   var rand = 0;
       rand = Math.round(Math.random() * 100000);
   drilldownurl = '/ibi_apps/WFServlet?IBIAPP_app=mashups&IBIF_ex=drilldownreport.fex&COUNTRY=' + country + '&RND=' + rand.toString();
   // Open the detail report in a new window.     
    window.open(drilldownurl, "", WProps1);
   // Open FocalPoint in a new window.  
    window.open("https://forums.informationbuilders.com/eve/forums/a/frm/f/7971057331","", WProps2);
  }
</SCRIPT>
</HEAD>
<BODY>
 !IBI.FIL.HLDMNRPT;
</BODY>
</HTML>
-HTMLFORM END

September 07, 2017, 08:40 AM

Enigma006

can anyone suggest on this plz?

September 07, 2017, 10:31 AM

RSquared

Please do a search on drillmenuitem.

September 07, 2017, 10:59 AM

David Briars

quote:
...So, I changed the code to this.
TYPE=DATA, COLUMN=N1, JAVASCRIPT=fn_drilldown(&START_DATE &END_DATE &TRACK),
...But parameters are not being passed. Am I doing something wrong?

Per the Creating Reports manual yes you can send amper variables via the JAVASCRIPT attribute.

The manual specifies that the amper variable be enclosed in single quotes.

So in your scenario, perhaps try...

 TYPE=DATA, COLUMN=N1, JAVASCRIPT=fn_drilldown('&START_DATE' '&END_DATE' '&TRACK')

September 08, 2017, 10:24 AM

J.L. Hinds

This updates two different frames when the user drills.

DRILL STATEMENT

TYPE=DATA, COLUMN=N2, TARGET='pdrill', JAVASCRIPT=parent.setControls(N1 \
&VAL_THREE.QUOTEDSTRING \
&TIME_VAL_THREE.QUOTEDSTRING \
&TIME_VAL_ONE.QUOTEDSTRING), $

JavaScript

function setControls(NEWMAN, VAL_THREE, TIME_VAL_THREE, TIME_VAL_ONE) {
IbComposer_setCurrentSelection('inputhidden1', NEWMAN, true);
IbComposer_execute('pdrill','graph1');
IbComposer_execute('bdrill', 'graph2');