How do I pass a variable to a ftp Protoco?

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,

Jbond007

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

Try

COMPUTE XYZ/A200='N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\'||REFDOC||.PDF';NOPRINT

and

TYPE=DATA,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
TARGET='_blank',
URL=FILE:///(XYZ),
COLUMN=REFDOC,
$

Depending on the browser you may need to right click the link and use the save target as option

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

i tested the code and it's not passing the value. it's passing it as literal

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:

URL=FILE:///(XYZ)

not like

URL='''file://N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\(XYZ)''',

I'm not sure about the URL=FILE: syntax though

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".

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

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,

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.

quote:

COMPUTE XYZ/A200='N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\'||REFDOC||.PDF'; NOPRINT

That was a typo on my part It's missing a '

COMPUTE XYZ/A200='N:\Business Management Services Share Data\Procurement Services\PAPO\FY 07-08\'||REFDOC||'.PDF'; NOPRINT

the file/// is correct and really you should change \ to /

Not being able to open the link directly is security related however as I mentioned right click on the link and select save target as.

By default IE and in fact most browsers now will not let you open a file on a local or mapped network drive.

save target as is the only option

This message has been edited. Last edited by: <JG>,

JG,

Thanks! It worked...


JLo