TABLE FILE EXPDET -*url='file://N:/Fiscal/Applications/DeptWide/hbcodes.pdf',$ -*$ href="file:///X:/714/DevStudio/050806_en/ds050806a/disk1/data_files/editdata.mso" SUM 'EXPDET.EXPDET.AMT' 'EXPDET.EXPDET.FFY' 'EXPDET.EXPDET.FM' 'EXPDET.EXPDET.REFDOC' BY 'EXPDET.EXPDET.REFDOC' BY 'EXPDET.EXPDET.FFY' BY 'EXPDET.EXPDET.FM' HEADING "" FOOTING "" WHERE FFY EQ '2007'; WHERE FM EQ '12'; WHERE REFDOC EQ 'S7554075'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=DATA, GRID=OFF, FONT='ARIAL', SIZE=9, TARGET='_blank', URL='''FILE://N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\S7554075.PDF''', COLUMN=REFDOC, $
Current this work when it's hard coded. What I want to do is when the select a value, it passes that value and pull the information. I'm not drilling down to a fex. It happens when a value is selected and an "file://" protocol is passed.
Thanks,
Jbond007This message has been edited. Last edited by: Kerry,
Depending on the browser you may need to right click the link and use the save target as option
April 26, 2010, 12:17 PM
jbond007
Thanks JG!
I tried it and i'm getting an error. I think I'm missing a quote on the compute. here's the code:
TABLE FILE EXPDET -*url='file://N:/Fiscal/Applications/DeptWide/hbcodes.pdf',$ -*$ href="file:///X:/714/DevStudio/050806_en/ds050806a/disk1/data_files/editdata.mso" SUM 'EXPDET.EXPDET.AMT' 'EXPDET.EXPDET.FFY' 'EXPDET.EXPDET.FM' 'EXPDET.EXPDET.REFDOC' COMPUTE XYZ/A200='N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\'||REFDOC||.PDF'; NOPRINT BY 'EXPDET.EXPDET.REFDOC' BY 'EXPDET.EXPDET.FFY' BY 'EXPDET.EXPDET.FM' HEADING "" FOOTING "" WHERE FFY EQ '2007'; WHERE FM EQ '12'; WHERE REFDOC EQ 'S7554075'; ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=DATA, GRID=OFF, FONT='TIMES NEW ROMAN', SIZE=10, TARGET='_blank', URL='''file://N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\(XYZ)''', COLUMN=REFDOC, $ TYPE=TITLE, STYLE=BOLD, $ TYPE=TABHEADING, SIZE=12, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=12, STYLE=BOLD, $ TYPE=FOOTING, SIZE=12, STYLE=BOLD, $ TYPE=SUBHEAD, STYLE=BOLD, $ TYPE=SUBFOOT, STYLE=BOLD, $ TYPE=SUBTOTAL, BACKCOLOR=RGB(210 210 210), $ TYPE=ACROSSVALUE, SIZE=9, $ TYPE=ACROSSTITLE, STYLE=BOLD, $ TYPE=GRANDTOTAL, BACKCOLOR=RGB(210 210 210), STYLE=BOLD, $ ENDSTYLE END 0 ERROR AT OR NEAR LINE 12 IN PROCEDURE alantestFOCEXEC * (FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: .PDF' (FOC009) INCOMPLETE REQUEST STATEMENT BYPASSING TO END OF COMMAND
7.61, nt Output: excel, pdf, html,
April 26, 2010, 12:42 PM
jbond007
i tested the code and it's not passing the value. it's passing it as literal
7.61, nt Output: excel, pdf, html,
April 26, 2010, 12:59 PM
Francis Mariani
The idea behind JG's suggestion is to build the URL link in a COMPUTE statement, so you need to modify the program - the Style-sheet code should look like:
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
April 26, 2010, 01:04 PM
jbond007
the "file://" protocol allows you to search within your network drive. It basically does a search on files and folders. XYZ is not being converted to the actual value of the field. It's coming in as "XYZ". It should be converted to "S7754075.PDF".
7.61, nt Output: excel, pdf, html,
April 26, 2010, 01:16 PM
Francis Mariani
A working example, using a WebFOCUS Application Folder as file repository:
-SET &ECHO=ALL;
SET MSG=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
-*-- Part 1 - create the PDF files
TABLE FILE CAR
SUM
COUNTRY
BY COUNTRY
ON TABLE HOLD AS H001
END
-RUN
-READ H001 NOCLOSE &COUNTRY.A10.
-REPEAT END_REP1 WHILE &IORETURN EQ 0;
-SET &FNAME = 'C:/ibi/apps_web/temp/' || STRIP(10, LOCASE(10, '&COUNTRY.EVAL', 'A10'), ' ', 'A10') || '.pdf';
FILEDEF HCOUNTRY DISK &FNAME
-RUN
TABLE FILE CAR
SUM SALES
BY COUNTRY
BY MODEL
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE HOLD AS HCOUNTRY FORMAT PDF
END
-RUN
-READ H001 NOCLOSE &COUNTRY.A10.
-END_REP1
-*-- Part 2 - create the report with links to the PDF files
TABLE FILE CAR
SUM
SALES
COMPUTE HFILE/A100 = '/approot/temp/' || STRIP(10, LOCASE(10, COUNTRY, 'A10'), ' ', 'A10') || '.pdf'; NOPRINT
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, TARGET='_blank', URL=(HFILE), $
ENDSTYLE
END
-RUN
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
April 26, 2010, 01:26 PM
Francis Mariani
Using the file protocol:
-*-- Part 2 - create the report with links to the PDF files
TABLE FILE CAR
SUM
SALES
COMPUTE HFILE/A100 = 'file://C:/ibi/apps_web/temp/' || STRIP(10, LOCASE(10, COUNTRY, 'A10'), ' ', 'A10') || '.pdf'; NOPRINT
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, TARGET='_blank', URL=(HFILE), $
ENDSTYLE
END
-RUN
Problem is that, even though the URL looks alright, nothing happens when it's clicked. If you copy the URL and paste it in a new window, it works.
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
April 26, 2010, 02:40 PM
jbond007
Francis,
The scenario is this:
A report is displayed with drill down. They select an item to drill down to. Rather than pointing to another fex, what it's doing is pulling a file in a shared drive.