January 20, 2010, 12:33 PM
<dksib>Drillmenuitem location
First of all, I can do this in javscript and link to new report inside of a new screen but the customer was told by IBI support that it can be done in the GUI using DRILLMENUITEM. So what I need to do is to create a multiple drill down and position it always in the middle of the frame and NOT directly below the selected row. Can this really be done? If so, can someone tell me how.
thanks
February 02, 2010, 01:42 PM
jncYou can't modify where the popup displays in the GUI. It's set to go below the selected row.
Here is an example of drillmenuitem code.
Run this.... then view source of the output.
TABLE FILE CAR
PRINT RETAIL_COST DEALER_COST
BY CAR
ON TABLE NOTOTAL
ON TABLE SET STYLE *
DEFMACRO=COND0001,MACTYPE=RULE,WHEN=N1 EQ 'BMW',$
DEFMACRO=COND0002,MACTYPE=RULE,WHEN=N1 NE 'BMW',$
TYPE=DATA,COLUMN=N1,MACRO=COND0001,
DRILLMENUITEM='DrillDown 1',FOCEXEC=50342517,TARGET='_blank',
DRILLMENUITEM='DrillDown 2',FOCEXEC=50342517,TARGET='_blank',$
TYPE=DATA,COLUMN=N1,MACRO=COND0002,
DRILLMENUITEM='DrillDown 1',FOCEXEC=50342517,TARGET='_blank',$
ENDSTYLE
END
Conceptually you could modify the js that is shipped with WebFOCUS, and try to revise where the popup goes. That would make for upgrade headaches, and likely cause other support problems.
If you have a way to do it, why not run with what you have.
February 02, 2010, 02:11 PM
Francis Marianiquote:
why not run with what you have
- probably because "the customer was told by IBI support that it can be done in the GUI using DRILLMENUITEM"!
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server