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

Focal Point

This topic can be found at:
https://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,

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

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,