I'm new to creating drill-downs so please forgive me if my questions are simple. I have 2 issues. The 1st is I've created a summary report and detail report using the Car File and I'd like to drill-down on the Country. When I click on a specific country the entire detail report shows. I want to only see detail for that Country. However when I click on the Title I do expect to see the entire detail report. How can I get data for the Country selected? My second issue is when I change the report format from HTML to AHTML it doesn't work at all....why? See Code below:
Car Summary Report:
TABLE FILE CAR
SUM
CNT.CAR.COMP.CAR
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
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 *
TYPE=DATA,
COLUMN=N1,
STYLE=UNDERLINE,
DRILLMENUITEM='View Case Listing',
FOCEXEC=cardetail.fex(PARAMETER=N1),$
TYPE=TITLE,
STYLE=BOLD,$
TYPE=TITLE,
COLUMN=N1,
COLOR='BLUE',
STYLE=BOLD+UNDERLINE,
DRILLMENUITEM='View Detail,
FOCEXEC=cardetail.fex(PARAMETER=N1),$

ENDSTYLE
END

Car Detail Report (cardetail.fex):
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.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
END

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

In the drilldown program, you need to apply the filter:

-DEFAULT &PARAMETER='FOC_NONE';
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR

WHERE COUNTRY EQ '&PARAMETER';

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
END

I applied the filter as suggested and it worked. However, when I changed the format from HTML to AHTML it doesn't work. Can this be achieved in AHTML?

The summary report has to be HTML, then the detail can be AHTML.

In v8.0.08, having the Summary report in AHTML format works for me. Perhaps the issue in v7.* is due to the multi-drilldown (drillmenuitem), though I don't recall having this problem.