水晶报告多问题. [英] crystal report multilne problem.

问题描述

我想打印如下报告:

108，xyz
pqr路，
xyz nagar

它存储在带有CR的sql数据库中，但是当我在Crystal报表中打印时，它的数据是(没有换行符)

xyz nagar xyz pqr路108号.


我该如何换行.

在我的表中，我使用varchar(250)
地址列
任何提示将不胜感激.


Hardik Shah.

Hi,

I want to print report like following:

108,xyz
pqr road,
xyz nagar

It is stored in sql database with CR, but when I print it in Crystal report data is (without line break)

108,xyz pqr road, xyz nagar.


How can I put line break.

In my table , i take address column with varchar(250)

any hint will be appreciated.


Hardik Shah.

推荐答案

如果数据是标准数据，并且您始终可以用换行符替换数据中的空格，则可以编写一些Crystal脚本来做到这一点.尝试研究如何创建
Replace({Table.Field}, '' '', CHR(13))


我不确定是用单引号还是双引号来查找空格，也不确定100％CHR(13)适用于回车换行.但是，如果您需要更多细节，则可以通过google找到正确的语法.

If the data is standard and you can always replace a space in the data with a line break, you can probably write some crystal script to do it. Try researching how to create a formula field [^]in crystal. Then using the Formula Workshop Formula editor screen, look under the String functions category for the Replace function. Your formula would be something like this:

Replace({Table.Field}, '' '', CHR(13))


I''m not sure if it''s single quotes or double quotes to find the space and I''m not 100% sure the CHR(13) works for the carriage return line feed. But if you need more specifics you can probably find the correct syntax via google.

这篇关于水晶报告多问题.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！