Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2009Report 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("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  

 
Posts: 822 | Registered: April 23, 2003Report 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("https://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, 2009Report 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, 2009Report 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, 2008Report 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: 822 | Registered: April 23, 2003Report 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: 74 | Registered: December 23, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders