October 10, 2006, 04:10 PM
LloydDrill Down
I am having a problem where I coded A drill down, which works for the most part. The problem is for certain users, the drill down URl that is returned begins as file://XXXX instead of
http://XXXX. The later is the correct way for the URL to appear and launches the report as expected. The former is incosistant with the URL format and returns an error. I would not call this random but it is correct for some users and not others. Any body know how to fix this?
PS. this wouldn't be mime-type problem would it?
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
October 11, 2006, 10:05 AM
Francis MarianiWhen you say it's happening for some users, do you mean it's happening on some user's workstations?
Are you drilling down to a WebFOCUS program or an HTML file or some other kind of file?
How is the drilldown link being created?
Is this in MRE or a self-service application?
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
October 11, 2006, 10:54 AM
LloydSorry I should have been more detailed....
It is a PDF report drilling into another PDF report. I have discovered that it is an Acrobat 7.0 problem.
Does anyone know a workaround for drilling down in acrobat 7.0?
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
October 11, 2006, 02:11 PM
Francis MarianiLooks like a bug in WebFOCUS:
TABLE FILE CAR
SUM SALES BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=SSS (COUNTRY=COUNTRY), $
ENDSTYLE
END
Doesn't generate the correct URL for the drilldown
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
October 11, 2006, 02:29 PM
LloydYes, that is the isssue. BUT, I beleive it is an Acrobat 7.0 that has the 'BUG'(feature maybe?), because the same code(including your test code) that fails on my machine runs fine on a machine with Acrobat ver. 6.0.
Any one know a work around?
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
October 11, 2006, 02:42 PM
drew billingsleaWe use WF 5.2.5 with Acrobat 7 and we had to add
-* make sure all drill-downs get the full URL
-*
SET FOCEXURL=http://
/ibi_apps/WFServlet
where you replace with whatever your URL is for that
and it correct that issue.
WF 7.6.6 Linux, FOCUS 7.8 zOS
October 11, 2006, 02:44 PM
drew billingsleasorry - looked like a tag to the software:
-* make sure all drill-downs get the full URL
-*
SET FOCEXURL=http://www.compname.com/ibi_apps/WFServlet
where
www.compname.com is whatever your URL is for that
WF 7.6.6 Linux, FOCUS 7.8 zOS
October 11, 2006, 02:58 PM
Francis Marianiquote:
SET FOCEXURL=http://www.compname.com/ibi_apps/WFServlet
Drew, thank you for that piece of information.
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
October 11, 2006, 05:18 PM
LloydProblem Solved.....
It is actually an Acrobat Bug. Upgrade to version 7.0.8 and the problem goes away.
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