I have coded the followinf drill down which works fine when the report is in HTML, but cannot get it to work in Excel(EXL2K).

Can anybody shed some light on what I am doing wrong? I tried many different combinations with no better better result.

 
TYPE=SUBHEAD, BY=B2, SIZE=10,  STYLE=BOLD, COLSPAN=2,
FOCEXEC=APP/top20str.fex(OUTPUT='&OUTPUT' TIMELINE='&TIMELINE' 
report_date=&report_date region=N1 ),
$

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

Are you getting any error?

What's happening when you run in excel format. If you put some more info, that will be helpful to figure out the issue.

Kamesh, I am not getting any error. The drill down just does not work, it appears as underlined text, but does not fire off the drill down request.

have you set the focexurl ?

Try this suggestions from CoderMonkey sometimes back,

EXL97 format does not always respect the WebFOCUS edit options.
� If drill-downs are included in a WebFOCUS report in Excel format, and the drill-down
reports fail to open, you must check the "Browse in same window" option for XLS file
types. If this setting is not selected, a WebFOCUS report in Excel format will be unable
to pass cookies to drill-down reports, and the reports will fail to open. To check the
"Browse in same window" option for XLS file types, perform the following steps:
1. Access Windows Explorer.
2. From the Tools menu, click Folder Options.
3. Select the File Types tab.
4. Select the XLS extension and then click Advanced.
5. Select the Browse in same window check box and then click OK.
6. Click Close to exit the Folder Options window.
� If you are using Windows NT Challenge/Response, Basic Web server authentication, or
both, and you attempt to open a WebFOCUS report that contains a HOLD FORMAT
EXL2K statement, you may need to type your user ID and password multiple times
before the Excel 2000 output document opens in the Web browser. To resolve this
issue, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

And also check this interesting discussion about it

https://forums.informationbuilders.com/eve/forums/a/...361098331#1361098331

Kamesh, that doesn't seem to be the problem i'm having. When the report format's in excel is does not appear to keep the hyperlink, it is just underlined text. For some reason it is not retaining the hyper link information when it is being formatted as EXL2K. One of the previous posts suggested that Excel is picky, and you have to use the correct OBject=Field syntax set properly, but I can't figure out what that is...

Basically I am using a BY field that doesn't print, except during the subheading. What are the proper style sheets parameters for that? ("TYPE=SUBHEAD, BY=B2," works in HTML, but not in EXCEL).

'not retaining the hyperlink info' means you don't have your FOCEXURL set in the primary report execution, as the post above says.
The Subhead thing would be unrelated.

OK, help me out here...What is focexurl?

this is how I coded the drill down:

quote:

FOCEXEC=APP/top20str.fex(OUTPUT='&OUTPUT' TIMELINE='&TIMELINE' report_date=&report_date region=N1 ),

This works for HTML, where does 'FOCEXURL' go?
Is 'FOCEXEC' the same as 'FOCEXURL'?

Lloyd,

What does the address line say when the excel file displays? Also, what is the contents of the hyperlink.

One last thing: I the redirect settings for .xht set to no for your webfocus server? (might have to check with your system people for that).

OK, I looked up FOCEXURL and coded my report to use it. But, I'm still not getting it to work from excel. The HTML version fires fine but not for Excel. It doesn't even apper to be a hyperlink, just underlined text.

quote:

FOCEXEC=APP/top20str.fex(OUTPUT='&OUTPUT' TIMELINE='&TIMELINE' report_date=&report_date region=N1 ),

Lloyd,

Do you actually have the word 'APP' in the FOCEXEC= statement? The 'APP/' should either be removed or the 'APP' should be the application directory name. I haven't tried this so please be advised that this is a guess.

See if this post can help.

https://forums.informationbuilders.com/eve/forums/a/...461098331#1461098331

Mickey: No I don't have 'APP' in the FOXEXEC Statement.

Prarie: Yeah, I read that thread but it doesn't appear to be my problem as I don't even get a hyper link let alone not being able to find the server.

I know I'm probably missing something obvious but what?

The app/ in a stylesheet statement for a drilldown is used in MRE where the focexec is accessed via app/focexecname.fex.

As most of you Guys seem to be self serve applications then this would not normally crop up.

T

OK, I know what's happening but not sure why, or how to fix it.

I amm trying to supress 'REGION' as column to save space, and only print it as a subheading. I want the drill down to fire from the subheading. When I remove NOPRINT from the by Field for REGION, and put a link there it works, but not in the subhead.

In the drill down wizard I see options for Column Title And Data, Column Data, and Column Title. Does this mean that you cannot attach a Drill Down to a Subhead?

Lloyd,
I tried an example for your problem and the code below seems working

rpt1.fex
---------
TABLE FILE CAR
PRINT CAR MODEL BODYTYPE DEALER_COST
BY CAR NOPRINT
ON CAR SUBHEAD
" CAR : ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBHEAD, BY=CAR, OBJECT=FIELD, ITEM=1, FOCEXEC=rpt2.FEX(NAME=P1 OUTPUT='EXL2K'),$
ENDSTYLE
END
-EXIT

rpt2.fex
-------
TABLE FILE CAR
PRINT CAR BODYTYPE MODEL DEALER_COST
WHERE CAR EQ '&NAME'
ON TABLE PCHOLD FORMAT &OUTPUT
END
-EXIT


Hope this helps

WFConsultant

WF 8105M on Win7/Tomcat

rpt1.fex
---------
TABLE FILE CAR
PRINT CAR MODEL BODYTYPE DEALER_COST
BY CAR NOPRINT
ON CAR SUBHEAD
" CAR : <CAR "
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=SUBHEAD, BY=CAR, OBJECT=FIELD, ITEM=1, FOCEXEC=MGMTTEST.FEX(NAME=P1 OUTPUT='EXL2K'),$
ENDSTYLE
END
-EXIT


rpt2.fex
--------
TABLE FILE CAR
PRINT CAR BODYTYPE MODEL DEALER_COST
WHERE CAR EQ '&NAME'
ON TABLE PCHOLD FORMAT &OUTPUT
END
-EXIT

Kamesh, I dont see a drill down in you example, or any Excel formatting, so exactly what is working?

Here is a sample I did with CAR:

 
SET FOCEXURL=http://SERVER/ibi_apps/WFServlet
TABLE FILE CAR
SUM
CAR AS 'CAR'
MODEL AS 'MODEL'
BODY AS 'BODY'
DEALER_COST AS 'DEALER, COST'
RETAIL_COST AS 'RETAIL, COST'
SALES AS 'SALES'
BY COUNTRY AS 'BY COUNTRY'
BY CAR  NOPRINT
BY MODEL  NOPRINT
BY BODY  NOPRINT
ON COUNTRY SUBHEAD
"SUBHEAD: <COUNTRY "
 
ON TABLE SET PAGE-NUM OFF
-*ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='LETTER', LEFTMARGIN=0.000000, RIGHTMARGIN=0.000000, 
TOPMARGIN=0.000000, BOTTOMMARGIN=0.000000, SQUEEZE=ON, ORIENTATION=LANDSCAPE, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=8, COLOR='BLACK', BACKCOLOR='NONE', 
STYLE=NORMAL, RIGHTGAP=0.125000, TOPGAP=0.013889, BOTTOMGAP=0.027778, $
TYPE=DATA, FONT='ARIAL', SIZE=8, COLOR='BLACK', 
BACKCOLOR=( 'WHITE' RGB(255 255 224) ), STYLE=NORMAL, $
TYPE=TITLE, STYLE=BOLD, $
TYPE=TABHEADING,  STYLE=BOLD, $
TYPE=TABFOOTING,  STYLE=BOLD, $
TYPE=HEADING, BACKCOLOR=RGB(210 180 140), SIZE=10, STYLE=BOLD, $
TYPE=FOOTING, STYLE=BOLD, $
TYPE=DATA,
COLUMN=N1, SIZE=10,  STYLE=BOLD, COLSPAN=2,
FOCEXEC=your report,
$
TYPE=SUBHEAD, SIZE=10,  STYLE=BOLD, COLSPAN=2,
FOCEXEC=your report,
$
ENDSTYLE
END

ps. just replace FOCEXEC with a report on your server, any will do.
pps. also Change SERVER to your server name.

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

My example before I gave the wrong filename in Focexec. That's why it didn't work for you.

TYPE=SUBHEAD, SIZE=10, STYLE=BOLD, COLSPAN=2,OBJECT=FIELD,ITEM=1,FOCEXEC=your report,$

Just replace the above line in your code and try. Remember you need to specify the report name in FOCEXEC.

Thanks Kamesh, I just tried your second example and it worked. I made the changes in my fex and it works also. I think I coded either ITEM or OBJECT wrong, when I was testing.