redaring trim functions in reports [message #143617] |
Fri, 21 October 2005 04:39 |
MEEENAR
Messages: 72 Registered: May 2005 Location: CHENNAI
|
Member |
|
|
hello,
I am doing one welcome letter report ..
in tHE LAYOUT EDITOR of the report I have pasted the format and
I fetch the address of the client from the database..
for example:
AddressFeild1: WHITE HOUSE
AddressFeild2: NEW NO 3
AddressFeild3: GANDHIJI STREET
AddressFeild4: VALASARAWAKKAM
AddressFeild5: CHENNAI
AddressFeild6: TAMIL NADU
AddressFeild7: INDIA
AddressFeild8: 600014
It works well ..
But if a client doesn't have values for AddressFeild2 and AddressFeild4 then that line is left empty..
then the letter looks odd...
If there is no value for that feild I don't want a empty line
I want the other feild values to be moved up..
so that there is no empty lines...
Pls help me out ...
|
|
|
Re: redaring trim functions in reports [message #143678 is a reply to message #143617] |
Fri, 21 October 2005 07:37 |
del_sandy
Messages: 22 Registered: February 2005 Location: Delhi
|
Junior Member |
|
|
Hi,
You can use format trigger to move up ur address feilds, Right this same format trigger for Text(Label) addr1 and Feild(value) Addr1 both.
E.g.
if :addr1 is null then
return(false);
else
return (TRUE);
end if;
And set Verticle Elasticity Property of Feild and Text 'VARIABLE'.
Hope it will work for u.
Cheers
Sandy
|
|
|