I have a field in database whose datatype is text. I am using SQL server 2008 R2 and crystal report 8.5. When I try to display this field , some data gets lost while displaying. Then I got solution from someone that,
Try to find the length of the String and the using Left, Mid and Right string functions you may display the data. But there is a space between one word.
Left({Database_field},255) & Mid({Database_field},256,510) & Mid({Database_field},511,765)......
I did this way But this way may split the word.
e.g. if the word "Code" has character no. as "C" = 254, "O" = 255 , "d" = 256, "e" = 257
then according to Left({Database_field},255), it will seperate/ break the word "Code" as into co de i.e. Co (Space) de in display.There will be space between one word.
How to tackle this issue?
thank you
What I have tried:
I got solution from someone that,
Try to find the length of the String and the using Left, Mid and Right string functions you may display the data. But there is a space between one word.
Left({Database_field},255) & Mid({Database_field},256,510) & Mid({Database_field},511,765)......
I did this way But this way may split the word.
e.g. if the word "Code" has character no. as "C" = 254, "O" = 255 , "d" = 256, "e" = 257
then according to Left({Database_field},255), it will seperate/ break the word "Code" as into co de i.e. Co (Space) de in display.There will be space between one word.
How to tackle this issue?
thank you