Compound Excel Drill Down

January 12, 2006, 03:36 PM

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

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

January 13, 2006, 01:17 AM

<JG>

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

January 13, 2006, 10:00 AM

Prarie

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.

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

January 27, 2009, 09:22 AM

RSquared

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

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

January 27, 2009, 09:55 AM

GinnyJakes

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,$

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

January 27, 2009, 10:06 AM

RSquared

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
/

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

January 27, 2009, 10:10 AM

Francis Mariani

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

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

January 27, 2009, 12:14 PM

RSquared

Francis,

It worked thanks. Go Leafs.

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

January 27, 2009, 04:47 PM

Francis Mariani

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.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server