Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Wrapping TABFOOTING Text in PDF Format (Part 2)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Wrapping TABFOOTING Text in PDF Format (Part 2)
 Login/Join
 
smiths
Platinum Member
posted
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,


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
KevinG
Platinum Member
posted Hide Post
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


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
smiths
Platinum Member
posted Hide Post
Kevin,

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

Thanks,
Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
KevinG
Platinum Member
posted Hide Post
Whoops,

This section came out wrong..

ON TABLE SUBFOOT
" -LONGVAR"
" -LONGVAR2"

Substitute Left Carat for -...

Sorry


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
mgrackin
Virtuoso
posted Hide Post
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!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
smiths
Platinum Member
posted Hide Post
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


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
smiths
Platinum Member
posted Hide Post
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


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
mgrackin
Virtuoso
posted Hide Post
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!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
smiths
Platinum Member
posted Hide Post
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


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Wrapping TABFOOTING Text in PDF Format (Part 2)

Copyright © 1996-2020 Information Builders