I have the following compound Excel spreadsheet.
Also below is a drilldown Fex. If you run the first part alone....the drill down works fine...combine them..the drill down does not work. Make it into compound HTML works fine. Is there some reason this would not work as a compound Excel...that anyone can think of? You should be able to cut and paste and run this. Thanks...

TABLE FILE CAR
SUM SALES
BY COUNTRY
FOOTING
""
""
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET STYLE *

TYPE=REPORT,
GRID=ON,
SIZE=10,
COLOR='RED',
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=WHY,$
ENDSTYLE
END
-*TABLE TWO
TABLE FILE CAR
SUM RC
BY COUNTRY
FOOTING
""
""
ON TABLE PCHOLD FORMAT EXL2K NOBREAK
ON TABLE SET STYLE *
TYPE=REPORT,
GRID=ON,
COLOR='LIME',
$
ENDSTYLE
END
-*TABLE THREE
TABLE FILE CAR
PRINT CAR
BY COUNTRY

ON TABLE PCHOLD FORMAT EXL2K CLOSE
ON TABLE SET STYLE *
$
TYPE=REPORT,
GRID=ON,
SIZE=10,
COLOR='YELLOW',
$
ENDSTYLE
END

Drill Down called why.fex

TABLE FILE CAR
PRINT SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END

Prarie

No consolation I suppose as you're 534 but it works perfectly in the latest 71 beta version.

I would check the hyperlink for the drilldown to make sure that it is being generated correctly.

JG

We are working on installing 7.
The thing I don't understand...if I run the first part of the fex, by itself...it works, just not combined.

I am currently having the same problem on 7.6.4. Does anyone have an answer?

Maybe you should post your code. The code above didn't work because the poster had neglected to put the drill stylesheet syntax in programs 2 and 3, i.e.

TYPE=DATA,
COLUMN=N1,
FOCEXEC=WHY,$

GinnyJakes,
Here is the report step code from the .fex
This code works when this is the only report. However once I put it the 'OPEN' and 'CLOSE' for the EXL2K, I cannot drill down.

/TABLE FILE HOLDHIGH
PRINT
DOCKETNUMBER1 AS 'Docket #'
DATEFILED1 AS 'Date Filed'
CASETYPE1 AS 'Case Type'
CASECOMMENTS AS ' Case Comments'
CASEDESCRIPTION AS 'Case Description'
Repodappl AS 'Respondent/Applicant'
BP8ACTION AS 'Last Action'
CHAIRMAN_NOTES
AS '........................... Notes / Comments ............................'
BY BP8CASEID AS 'BP8CaseId'
FOOTING
" "
" Total"
" Number Of "
" Open Cases"
" &NUMCASES"
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.500000,
BOTTOMMARGIN=0.500000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
TITLETEXT='&BUREAU RESP BUREAU - ALL CASES',
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
HEADALIGN=BODY,
$
TYPE=DATA,
COLUMN=N8,
TARGET='_blank',
FOCEXEC=AuditHistoryReportCMR(BP8CASEID=N1),
$
ENDSTYLE
END
/

As JG suggested, did you take a look at the drilldown hyperlink - is it generated correctly?

You need to set FOCEXURL when the drilldown is in an Excel or PDF document.

Adding the following made the program work in v5.3.4 and v7.6.5:

SET FOCEXURL='http://bic-qa-wfweb-6.bmogc.net/ibi_apps/WFServlet?'

Running without the FOCEXURL setting may generate an invalid drilldown hyperlink, in v5.3.4 the invalid URL looks like this:

C:\cgi-bin\ibi_cgi\ibiweb.exe?IBIF_webapp=\ibi_apps&IBIC_server=EDASERVE&IBIAPP_app=fmarian&IBIF_ex=fmfptest1dd&CLICKED_ON=&

Francis,

It worked thanks. Go Leafs.

RSquared,

I'm glad it worked.

The Leafs are 5th last in the league standings and the only place they're go-ing is down.

Cheers.