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,

COMPUTE URLTXT/A150='X:\Main\my reports\D&|H\DeptHeadlst.PDF';
..........
TYPE=REPORT,
TARGET='_blank',
URL=(URLTXT),
$

Anyone, I tried single quotes around the path and double...no dice. This seems pretty basic, what am I doing wrong?

did you try my suggestion at all?

sorry - I missed it..not sure how. Where does this go in the fex..at the beginning? In a define, after the table statement?

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)

if I move the compute under my TABLE statement I get this error:


(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 70: URL=(URLTXT)

Compute needs a TABLE FILE... SUM before it. Something like:

  
TABLE FILE CAR
SUM COMPUTE URLTXT/A150='C:\Downloads\Corporate file name.pdf'; NOPRINT 

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

If you don't want to see the COMPUTE add a NOPRINT to the right of ;

...made it a noprint...seems to work...thanks all!