formula field exceeding 254 characters

[wisko]

hi all

im a newbie to this forum as well as for CR. so pls bare with me if im being a trouble to you in any manner..

i've developed a crystal report using CR 8.5.
i had to create a formula field as to generate a text string & another formulated field as well as variable fields which in some instances exceeds 254 characters.
i've been tried to break the same field into two & process but it has also showed some issues in continuity of my report phrase.

i hope you would have got some idea of what im saying..

pls help me to overcome the problem.. any suggestion would be much helpful

thanks in advance

my formula is as follows

if {ado.var_fld_val}="D0" // variable fld value
then 
chr(13)+'Text_String1' //text string has over 150 characters
+{@FullName} // this can be grow almost upto 50 characters
+'Text_String2' //over 50 characters
+replace(totext({?var_val}),"$","") // amount (characters count can be vary)

 

[Turkbear]

Hi,
What is the source of the text strings?

If this result is only needed when the IF test is satisfied, try
placing 3 or 4 separate fields next to each other, but not concatenated and suppress each of them with a variant of the IF test so it only gets shown when the IF test in your original formula is met:
{ado.var_fld_val} <> "D0"

Trim('Text_String1') + " "  Trim(@FullName)+ " " Trim('Text_String2' + " " Trim(replace(totext({?var_val}),"$","") )

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[wisko]

Hi Turkbear

thanks for your reply.. as i said i did try earlier to use separate fields instead of one field, but ended up with getting some report format issues.
i should give it one more try as per your suggestion

so thanks again Turkbear