Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Drill down - Multiple Requests
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Drill down - Multiple Requests
 Login/Join
 
Master
posted
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,


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Master
posted Hide Post
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("http://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  

 
Posts: 806 | Registered: April 23, 2003Reply With QuoteReport This Post
Master
posted Hide Post
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("http://forums.informationbuilders.com/eve/forums/a/frm/f/7971057331","", WProps2);
  }
</SCRIPT>
</HEAD>
<BODY>
 !IBI.FIL.HLDMNRPT;
</BODY>
</HTML>
-HTMLFORM END   




8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Master
posted Hide Post
can anyone suggest on this plz?


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
Please do a search on drillmenuitem.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Master
posted Hide Post
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')
 
Posts: 806 | Registered: April 23, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
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');


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 75 | Registered: December 23, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Drill down - Multiple Requests

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.