如何在水晶报表上显示超过256个字符的文本 [英] How to show text more than 256 characters on crystal report

问题描述

我在数据库中有一个数据类型为text的字段。我正在使用SQL Server 2008 R2和crystal report 8.5。当我尝试显示此字段时，某些数据会在显示时丢失。然后我得到了某人的解决方案，

尝试找到String的长度以及使用Left，Mid和Right字符串函数可以显示数据。但是在一个单词之间有一个空格。



左（{Database_field}，255）&中（{Database_field}，256,510）& Mid（{Database_field}，511,765）......





我这样做但这种方式可能会分裂。

例如如果代码一词的字符号为。因为C= 254，O= 255，d= 256，e= 257

然后根据Left（{Database_field}，255），它将分离/打破单词代码作为 co de 即Co（Space）de显示。一个单词之间会有空格。

如何解决这个问题？

谢谢



我尝试过：



我从某人那里得到了解决方案，

尝试找到String的长度以及使用Left，Mid和Right字符串函数可以显示数据。但是在一个单词之间有一个空格。



左（{Database_field}，255）&中（{Database_field}，256,510）& Mid（{Database_field}，511,765）......





我这样做但这种方式可能会分裂。

例如如果代码一词的字符号为。因为C= 254，O= 255，d= 256，e= 257

然后根据Left（{Database_field}，255），它将分离/打破单词代码作为 co de 即Co（Space）de显示。一个单词之间会有空格。

如何解决这个问题？

谢谢

解决方案

如何将文字换行Crystal Reports中的字段 - Blackbaud知识库 [ ^ ]

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

解决方案

How to wrap text on fields in Crystal Reports - Blackbaud Knowledgebase[^]

这篇关于如何在水晶报表上显示超过256个字符的文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！