I'm concatenating two fields and displaying in my report. Right now, the way it displays as

AA/A5='xxxxx';
BB/A5='XXXXX';
CC/A12=AA | ' ' | BB ;


output
CC
xxxxx XXXXXX

I need the output to show as,

CC
xxxxx
XXXXX

It may depend on your output type. Can you get it to WRAP at the width of 5 characters?

WRAP wont work in HTML

Have you tried concatenating ascii value of 13 (carriage return) instead of ' ' (space)?

If you want more information check out this ascii table.

The WF function you will need is HEXBYT('13', 'A1');

Is there any reason you aren't using the OVER command to print your two original fields?

Hi,

I think following code may be helpful for you....

TABLE FILE GGSALES
SUM
UNITS OVER
DOLLARS
ACROSS
CATEGORY
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END

Thanks & Regards,
Goldy

I'm not using OVER because Field1 has to print on 1st line after that only Field2 has to print in each line.

When ever BY value changes, then Field1 has to print as 1st line and Field2 will follow with multiple lines.

Kamesh,
If your output is HTML give this a try it works in WF 7.1.0
DEFINE FILE CAR
CAR_COUNTRY/A40 = CAR || '
' || COUNTRY;
END
-RUN
TABLE FILE CAR
PRINT
CAR
COUNTRY
CAR_COUNTRY
END
-RUN[/code]

This message has been edited. Last edited by: <Mabel>,

Hi CurtisA,

Your code works good for HTML. I'm using WRAP for PDF. This solves my problem. Thanks a lot.

-Kamesh

Like BR in html, is there anything else we can use in PDF other than WRAP.

Did you try adding the ascii character for a carriage return.

Yes, that didn't work.

I just did the wrap in 5.33 with both html and pdf, and it worked fin.

TYPE=REPORT,
COLUMN=N3,
WRAP=0.541667,

You might have to play with the sizing (in inches) to get exactly what your looking for.

I'm not able to use the WRAP as my values are dynamic.

Field1 | ' ' | Field2

Output
-------
Field1
Field2

Field1 will vary for each record.

If the result set isn't too big, you can always use a sledge hammar and append two outputs together.

for example:

TABLE FILE CAR.MODEL
PRINT
COMPUTE C_SORT/I5 = 1;
COMPUTE C_COL/A100 = WARRANTY;
BY CAR
BY MODEL
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS TT FORMAT ALPHA
END

FILEDEF TT DISK TT.FTM (APPEND

TABLE FILE CAR
PRINT
COMPUTE C_SORT/I5 = 2;
COMPUTE C_COL/A100 = BODYTYPE;
BY CAR
BY MODEL
WHERE COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS TT FORMAT ALPHA
END

TABLE FILE TT
PRINT C_COL
BY CAR
BY MODEL
BY C_SORT NOPRINT
END

I can't do that...my report is complicated compound report...I can't change much now as already most of the testing is completed on that...

I'm just trying to put some patch...