Hi,

I have a field in database as RT|RG|VC is it possible to print that field in PDF as
RT
RG
VC
That is by replacing the pipe with a newline?

Thank you
Sakeesh

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

There are many ways to to this.

I would suggest, if it works in your report, to change the | char for a space, and wrap the field to an appropriate width.

You might try using MARKUP=ON in the StyleSheet and replace the pipe with HTML tag <br>.

quote:

HTML tag <br>

Not in PDF Dan.

quote:

Not in PDF

Also not with MARKUP=ON ? Correct me if I'm wrong please, but I thought that's what MARKUP is for, to propagate/translate html stuff into PDF..

Sorry, I see now that Sakeesh is using WF version 5.2.5. MARKUP for PDF wasn't added until one of the 7.6 releases.

with little searching I got this function CTRAN tried using it but instead of new line it is giving space, does anybody have any idea why

ALEN/I2 = LENV(SUN_TYPE,ALEN);
SUN_C/A40 = CTRAN(ALEN, SUN_TYPE,124, 10, SUN_C);

Below is the style sheet added

ON TABLE SET STYLE *
UNITS=PTS,
PAGESIZE='C',
LEFTMARGIN=100,
RIGHTMARGIN=30,
TOPMARGIN=10,
BOTTOMMARGIN=35,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
BORDER=LIGHT,
$
ENDSTYLE

could the issue be with style used?

got some more idea ... that was to use LINEBREAK in style sheet as below
TYPE=REPORT,
BORDER=LIGHT,
LINEBREAK='LF',
$

but this is giving error as
(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 1 LINEBREAK

Probably the version i am using doesn't support LINEBREAk. Does any one know the equivalent or any alternate command?

One of the issues you have is the release of WebFOCUS. Version 5.2.5 is old and unsupported by IBI, Its "Functionally Stabilised".

There are many options that are not available to you.

If you have any documentation related to that release, please check it to see if the options you are trying exist.

You also have given us very little information on the report.

Perhaps if you could post your existing code, Master files, and expected output, we could suggest something that will work.

Waz,

Your initial suggestion to add space and wrap the field worked in PDF. For excel CTRAN(ALEN, SUN_TYPE,124, 10, SUN_C) worked.

Thank you
Sakeesh

Sakeesh, glad to hear that you have solved your issue.

Please change your first post in this thread and add [SOLVED] to the title.