Is there a way to get multiple consecutive long defined variables to wrap properly in the TABFOOTING in PDF format?

When I have 2 variables in the same line and try to wrap them, the second variable appears beside the first variable, and not below it, which is what I need.

I would like to handle this on just one line if possible.

Here is the code:

 
-SET &LONGVAR = 'FGFGHGHGHGFHGGJGHJHJHJHKH KJKJKJKJKJKJKJKJKJKJKHKJKJHKHKH' |
-               '1ABCDEFGHIJKLMNOPQRSTUVWX YZ2ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
-               '3ABCDEFGHIJKLMNOPQRSTUVWX YZ4ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
-               '5ABCDEFGHIJKLMNOPQRSTUVWX YZ6ABCDEFGHIJKLMNOPQRSTUVWXYZ';

-SET &LONGVAR2 = 'XXXFGFGHGHGHGFHGGJGHJHJHJHKH KJKJKJKJKJKJKJKJKJKJKHKJKJHKHKH' |
-               '1ABCDEFGHIJKLMNOPQRSTUVWX YZ2ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
-               '3ABCDEFGHIJKLMNOPQRSTUVWX YZ4ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
-               '5ABCDEFGHIJKLMNOPQRSTUVWX YZ6ABCDEFGHIJKLMNOPQRSTUVWXYZ';

DEFINE FILE CAR
  LONGVAR /A512 = '&LONGVAR' ;
  LONGVAR2/A512 = '&LONGVAR2' ;
END

TABLE FILE CAR
  PRINT CAR
  BY COUNTRY
  ON TABLE SUBFOOT
    "<LONGVAR <LONGVAR2"
  ON TABLE PCHOLD FORMAT PDF

  ON TABLE SET STYLE *
    UNITS=IN,
    PAGESIZE='LEGAL',
    ORIENTATION=LANDSCAPE,
    SQUEEZE=ON, $

    TYPE=TABFOOTING, FONT='ARIAL', SIZE=9, 
    WRAP=5, GRID=ON, $
  ENDSTYLE
END
 

Thanks for your help!
Sean

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

You mean like this?

-SET &LONGVAR = 'FGFGHGHGHGFHGGJGHJHJHJHKH KJKJKJKJKJKJKJKJKJKJKHKJKJHKHKH' |
- '1ABCDEFGHIJKLMNOPQRSTUVWX YZ2ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
- '3ABCDEFGHIJKLMNOPQRSTUVWX YZ4ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
- '5ABCDEFGHIJKLMNOPQRSTUVWX YZ6ABCDEFGHIJKLMNOPQRSTUVWXYZ';

-SET &LONGVAR2 = 'XXXFGFGHGHGHGFHGGJGHJHJHJHKH KJKJKJKJKJKJKJKJKJKJKHKJKJHKHKH' |
- '1ABCDEFGHIJKLMNOPQRSTUVWX YZ2ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
- '3ABCDEFGHIJKLMNOPQRSTUVWX YZ4ABCDEFGHIJKLMNOPQRSTUVWXYZ' |
- '5ABCDEFGHIJKLMNOPQRSTUVWX YZ6ABCDEFGHIJKLMNOPQRSTUVWXYZ';

DEFINE FILE CAR
LONGVAR /A512 = '&LONGVAR' ;
LONGVAR2/A512 = '&LONGVAR2' ;
END

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE SUBFOOT
" " ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='LEGAL',
ORIENTATION=LANDSCAPE,
SQUEEZE=ON, $

TYPE=TABFOOTING, FONT='ARIAL', SIZE=9,
WRAP=5, GRID=ON, $
ENDSTYLE
END

Kevin

Kevin,

I think part of your code got lost. Did you wrap [ code ] [ /code ] (without spaces) around your code?

Thanks,
Sean

Whoops,

This section came out wrong..

ON TABLE SUBFOOT
" -LONGVAR"
" -LONGVAR2"

Substitute Left Carat for -...

Sorry

The FIELDs are treated as two seperate entities and therefore will wrap in seperate cells/columns. You can create an Alpha format field up to 4k(?) (I think) and therefore should create a DEFINE field with them concatenated together.

LONGVAR/A1024 or LONGVAR/A2048 or etc, etc.

Thanks, but I was hoping to put it all on one line as a continuous stream. (I edited my original post just as you were replying).

Any way to handle it on one line? Otherwise multiple lines will have to be my fallback.

Thanks,
Sean

Mickey,

The longest format that seemed to work for me is 1024. However, I need to handle roughly up to 10K in text.

So it looks like I'm stuck handling each variable in a separate line I guess?

Thanks,
Sean

Sean, Check the posts in the "Limitations..." thread. DocServices just posted a note that the limit is 4k but slightly less in so cases. Maybe this is in releases later thatn 5.2.3.

In any event, 4k won't hold 10k.

Try looking into TX format fields. If they can hold up to 10k then they may be a solution. They inherently wrap according to their length definition. For example, a field of TX100 would wrap at with lines up to 100 characters long. Stylesheet syntax would not be necessary in this case.

Check it out.

Thanks for the info Mickey! I'll check it out.

I did implement the solution using separate lines for each long string for PDF format, and put all the variables on the same line for HTML and Excel format. It was a somewhat painful exercise (since it's a bunch of generic processing that I required), but it works.

Thanks for all your assistance!
Sean