| Oracle Developer 2000 Reports Problem [message #172865] |
Thu, 18 May 2006 07:17  |
ketan.pawar
Messages: 1
Registered: May 2006
|
Junior Member |
|
|
Report is developed in D2K Reports 6i
There is paragraph as follows
< variable text 1><Telephone No><variable text 2>
eg this is sentence one contact 123 22 22 22 this is sentence two.
Because of variation of length of < variable text 1> at runtime, report displays this paragraph as follows -
this is sentence one this is sentence one this is contact 123 22 22 22 this is sentence two.
Please note that the telephone number is displayed partly on line 1 and partly on line 2. This is not acceptable.
Please suggest a solution to display the entire telephone no in one line and also justify the first line so that the entire text appears to be in same paragraph ie it is continuous, there are no unnecesseary spaces
ie the expected text is
this is sentence one this is sentence one this is contact
123 22 22 22 this is sentence two.
|
|
|
|
| Re: Oracle Developer 2000 Reports Problem [message #173025 is a reply to message #172865] |
Fri, 19 May 2006 01:13  |
RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
|
Senior Member |
|
|
Hi,
You could do this with a format trigger on the item like (pseudo code)
if length( textstring) > mylen then
textstring = (variable text 1) || chr(10) || telefonenumber || (variable text 2)
end if
You have to find out (trial and error) what the value of mylen is. It will depends on the font you're using.
HTH,
Regards,
Rob Zijlstra
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
