Focal Point
[CLOSED] Neutralizing a drill-down component in a drill-down list.

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7947031196

February 22, 2019, 02:07 PM
Ron Hansard
[CLOSED] Neutralizing a drill-down component in a drill-down list.
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
February 22, 2019, 02:44 PM
Tom Flynn
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
February 23, 2019, 06:34 PM
dbeagan
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.06
Win10 / IE11
AHTML EXL2K PDF