So I have a report header with a hyperlink. It works if my URL path and file name have no spaces. It fails where there is a space...as is the case below. How do I adjust the syntax to account for the spaces?
TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=10, SIZE=8, COLOR=RGB(255 102 0), TARGET='_blank', URL=X:\DEPT\my reports\Dept Head List.PDF,This message has been edited. Last edited by: FP Mod Chuck,
sorry - I missed it..not sure how. Where does this go in the fex..at the beginning? In a define, after the table statement?
WebFOCUS 8206.08 Windows, All Outputs
November 15, 2017, 12:24 PM
RobertF
if at the beginning, line 1, I get this:
0 ERROR AT OR NEAR LINE 1 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC001) THE NAME OF THE FILE OR THE WORD 'FILE' IS MISSING 0 ERROR AT OR NEAR LINE 13 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC324) THE PARAMETER TO BE SET IS NOT RECOGNIZED: RLSPACE (FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 144: URL=(URLTXT)
WebFOCUS 8206.08 Windows, All Outputs
November 15, 2017, 12:29 PM
RobertF
if I move the compute under my TABLE statement I get this error:
(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 70: URL=(URLTXT)
WebFOCUS 8206.08 Windows, All Outputs
November 15, 2017, 12:31 PM
BabakNYC
Compute needs a TABLE FILE... SUM before it. Something like:
TABLE FILE CAR
SUM COMPUTE URLTXT/A150='C:\Downloads\Corporate file name.pdf'; NOPRINT
WebFOCUS 8206, Unix, Windows
November 15, 2017, 12:32 PM
Frans
TABLE FILE CAR
PRINT
COMPUTE URLTXT/A150 = 'X:\Main\my reports\D&|H\DeptHeadlst.PDF';
BY MODEL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=REPORT,
URL=(URLTXT),
TARGET='_blank',
$
ENDSTYLE
END
I tried the SET method and get this error; note I must use: |, when I use: || it errors out altogether.
ERROR AT OR NEAR LINE 11 IN PROCEDURE ADHOCRQ FOCEXEC * (FOC324) THE PARAMETER TO BE SET IS NOT RECOGNIZED: RLSPACE (FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 143: URL=(URLTXT2)
Using the compute now works but now I get the path value on every row printed...getting closer though...
WebFOCUS 8206.08 Windows, All Outputs
November 15, 2017, 01:34 PM
BabakNYC
If you don't want to see the COMPUTE add a NOPRINT to the right of ;
WebFOCUS 8206, Unix, Windows
November 15, 2017, 01:35 PM
RobertF
...made it a noprint...seems to work...thanks all!