This message has been edited. Last edited by: Kerry,
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 01, 2006, 04:43 PM
Kamesh
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.
WFConsultant
WF 8105M on Win7/Tomcat
February 01, 2006, 04:54 PM
Lloyd
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.
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 01, 2006, 04:58 PM
<peyton>
have you set the focexurl ?
February 01, 2006, 05:01 PM
Kamesh
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).
WFConsultant
WF 8105M on Win7/Tomcat
February 01, 2006, 05:02 PM
Kamesh
And also check this interesting discussion about it
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).
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 01, 2006, 05:41 PM
susannah
'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.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
This works for HTML, where does 'FOCEXURL' go? Is 'FOCEXEC' the same as 'FOCEXURL'?
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 01, 2006, 11:47 PM
dhagen
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).
February 01, 2006, 11:47 PM
Lloyd
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.
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
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.
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?
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 02, 2006, 12:00 PM
Tony A
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
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
February 02, 2006, 12:39 PM
Lloyd
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 Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 02, 2006, 12:44 PM
Kamesh
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
February 02, 2006, 12:45 PM
Kamesh
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
WFConsultant
WF 8105M on Win7/Tomcat
February 02, 2006, 12:52 PM
Lloyd
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,
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7
Windows Server 2005 Windows Server 2008
Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0
February 02, 2006, 01:00 PM
Kamesh
My example before I gave the wrong filename in Focexec. That's why it didn't work for you.
Just replace the above line in your code and try. Remember you need to specify the report name in FOCEXEC.
WFConsultant
WF 8105M on Win7/Tomcat
February 02, 2006, 01:04 PM
Lloyd
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.
Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com
