Hi All,

I am new to reports registered in Oracle Apps11i.

My requirement is in a particular text field (Source Database Column of type varchar2(20), it has to print 10 Chars in a line, if it exceeds 10 Characters, remaining has to be wrapped and printed in next line.

How to achieve this result? Can anyone help me with this?

Options I have tried is:
Designed in Character units.
Font Size is Arial 10
Vertical Property : Expandable
The size of the field in layout has been set using character cell 10.

The problem with the above option is while running in Apps, each time in the first line the no. of characters displayed varies depending on the case of the char (upper or lower or mixed case) and the char of the field value.

Thanks in advance!

Regards,
Gowri.

step1 ) create a field with Fixed in Horizontal and vertically Expand
Step2) Create a Function to make a string like

l_string := Substr (’XXXXXXXXXXXXXXXXXXXXXX’,1,10)
l_string := l_String ||fnd_global.newline || substr(’XXXXXXXXXXXXXXXXXXXXXX,11,10);

then return l_string This function must be source of the Step1

Should work.  Fnd_global.newline is actually adding chr(10) which is a ENTER KEY to start with a new line. Logic you need toadd. but idea is after each 10 character u use chr(10).
SJ