I have coded 2 simple fexes to utilize the
DRILL DOWN functionality in App Studio 8204.

Here is the "target" fex:

TABLE FILE CAR
PRINT
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(|FORMAT=A10).COUNTRY:.QUOTEDSTRING;
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 *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
ENDSTYLE
END

Here is the "source" fex:

TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST AS 'DEALER'
     CAR.BODY.RETAIL_COST AS 'RETAIL'
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
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 *
  INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=DATA,
DRILLMENUITEM='DrillDown 1',
FOCEXEC=REPORT105(PARAMETER=N1),
TARGET='_top',
$
ENDSTYLE
END

When I run the "source" focexec, I see a report looking
like this:

COUNTRY DEALER RETAIL SALES 
ENGLAND  37,853  45,319  12000  
FRANCE  4,631  5,610  0  
ITALY  41,235  51,065  30200  
JAPAN  5,512  6,478  78030  
W GERMANY  54,563  64,732  88190  

I am expecting to see the data elements in the COUNRTY column
(ENGLAND, FRANCE, ITALY, JAPAN, and W GERMANY) display a clickable
link to the "Target" focexec.

Unfortunately, I see that every cell in the report has a
clickable link to the target focexec. (Note: The title columns display
without the link).

Can anyone point out what is wrong ?

Thank you.

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

Can you try adding the COLUMN attribute to the StyleSheet command?

TABLE FILE CAR
SUM 
    CAR.BODY.DEALER_COST AS 'DEALER'
    CAR.BODY.RETAIL_COST AS 'RETAIL'
    CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
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 *
 INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/jellybean_combo.sty,
 $
 TYPE=DATA, COLUMN = COUNTRY,
  DRILLMENUITEM='DrillDown 1',
  FOCEXEC=REPORT105(PARAMETER=N1),
  TARGET='_top', 
 $
 TYPE=DATA, COLUMN = COUNTRY, COLOR=BLUE,$
ENDSTYLE
END  

This message has been edited. Last edited by: David Briars,

TYPE=DATA,
     DRILLMENUITEM='DrillDown 1', COLUMN=COUNTRY,
          FOCEXEC=REPORT105(PARAMETER=N1),
          TARGET='_top',
$

I get an error:
INVALID KEYWORD: COLUMN

This code WORKS !

TABLE FILE CAR
SUM 
     CAR.BODY.DEALER_COST AS 'DEALER'
     CAR.BODY.RETAIL_COST AS 'RETAIL'
     CAR.BODY.SALES
BY  CAR.ORIGIN.COUNTRY
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 *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=DATA,
 	COLUMN=N1,
    FOCEXEC=REPORT105(PARAMETER=N1),
    TARGET='_top',
$
ENDSTYLE
END
-RUN

I always reference COLUMN=columnname instead of N notation. That way if the sort order changes the drill down still works.

In your case, TYPE=DATA, COLUMN=COUNTRY, ..... will always pass the value of COUNTRY regardless of where COUNTRY is located in the TABLE request. However, COLUMN=N1 will pass the value of whatever field happens to be the first BY field.

Just a thought

TYPE=DATA,
   DRILLMENUITEM='DrillDown 1', COLUMN=COUNTRY,
   FOCEXEC=REPORT105(PARAMETER=N1),
   TARGET='_top',
$

Should maybe be

TYPE=DATA,
   COLUMN=COUNTRY,
   DRILLMENUITEM='DrillDown 1',
   FOCEXEC=REPORT105(PARAMETER=N1),
   TARGET='_top',
$

I think that COLUMN must appear before any other command