mr_suleyman
28th September 2004, 14:58
Hello all ,
On my report layout , I have 3 columns. One of them is item column.
In my DB ,items have diffrent lengths like 12 ,4,16. I want to get customized print-out like.

LOC;ITEM;STOC;

but I get like that

LOC;0322ATC___________;___8; |____ means blank
--- ;--------___________;__67;

My aim is to get form on print-out like that
LOC;0322ATC;8;
---;---------;67;

ITEm is string , STOC is long. How to remove blank spaces on report layout?
I know strip,shiftl... but how to use it on report layouts?

steveauckly
28th September 2004, 15:04
I believe you'll have to format a string variable and print this variable in your report layout instead of the individual fields.

mr_suleyman
28th September 2004, 16:14
I know that. But How to format variable on predefined on REPORT LAYOUT.??

steveauckly
28th September 2004, 16:22
hopefully this helps:

string print.string(60)

print.string = concat$(";",strip$(loc),strip$(item),str$(stoc))

Then, in the report, just add print.string to the layout. There is no formatting since it is already in the string.

mark_h
28th September 2004, 16:24
Declare an external string variable in the report. Put this variable on the report layout. Something like this:


declaration:
table ttdilc101
extern domain tcmcs.str20 check.msg

detail.1:
before.layout
check.msg = str$(tdilc101.strs)
check.msg = strip$(tdilc101.loca) & ";" & strip$(check.msg)


Where tdilc101.loca and tdilc101.strs are input fields to the report. The variable check.msg is printed in the detail.1 layout. You can format the message or string variable using all the string functions. I believe this is what Steve was referring to.

Mark

mr_suleyman
28th September 2004, 17:05
Thanks mark and steve . I understand that.

Thank you ...