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     [CLOSED] Neutralizing a drill-down component in a drill-down list.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Neutralizing a drill-down component in a drill-down list.
 Login/Join
 
Member
posted
Using the CAR file I am creating a drill-down on COUNTRY. The list of countries is then displayed with links to the appropriate detail procedure. I need to turn off the drill-down capabilities of the last COUNTRY in the drill list. How do you do it?

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


Release 8.2.1
Microsoft Server 2012R2
 
Posts: 11 | Location: Kentucky | Registered: February 06, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
SET BYDISPLAY=ON
TABLE FILE IBISAMP/CAR
SUM
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
BY  CAR.COMP.CAR
 ON TABLE HOLD 
END
-RUN

TABLE FILE HOLD
SUM
    COUNTRY
 ON TABLE HOLD AS HOLD1
END
-RUN

-READ HOLD1 &COUNTRY.A10.
-TYPE &COUNTRY

TABLE FILE HOLD
PRINT
     SALES
      COMPUTE DRILL_FLAG/A1 = IF COUNTRY EQ '&COUNTRY' THEN 'N' ELSE 'Y'; NOPRINT
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

TYPE=DATA,
COLUMN=COUNTRY,
     FOCEXEC=DRILL_TEST, WHEN = DRILL_FLAG EQ 'Y',$
ENDSTYLE
END

-EXIT


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1942 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
How about this:
 TABLE FILE ibisamp/car
  SUM MAX.COUNTRY NOPRINT
  SUM SALES
   BY COUNTRY
   BY CAR
  ON TABLE SET BYDISPLAY ON
  ON TABLE SET STYLE *
  TYPE=DATA, COLUMN=COUNTRY,
  FOCEXEC=somefex, WHEN=COUNTRY NE MAX.COUNTRY,$
  ENDSTYLE
 END  

This message has been edited. Last edited by: dbeagan,


WF 8.2.03
Win10 / IE11
AHTML EXL2K PDF COMT WP ZIP
 
Posts: 134 | Registered: October 19, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Neutralizing a drill-down component in a drill-down list.

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