如何将数据库字段的长度拆分为特定宽度 [英] How to Split a database field's length into a specific width

问题描述

我想拆分在水晶报告上显示的数据库字段

表示水晶报告上的字段

like-xxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxx

但我希望打印如

xxxxxxxxxx xxxxxxxxxxxxxxxx

xxxxxxxxxxxxx xxxxxx





我的问题是，当我们在水晶报表上拖动数据库字段名称时，它显示了水晶报表上由数据库中该字段表示的值，该值我要吐出

例如一个地址字段，它可以在边数据库中具有较大的值，当我在水晶报表上拖动该地址字段时，显示整个地址值在单行中如

< br $>
地址

---------------------------------- ------------

xxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx，xxxxxxxxxxxx

------------------ ----------------------------

但希望将该地址拆分为更多比一行符合特定长度，这意味着我希望显示该地址如



地址

-------- ---------------------------------

xxxxxxxxxxxxxxxxxxxxxxxx

xxxxxxxxxxxxxxxx，xxxxxxxxxxxx

--------------------------------------- -

有可能在水晶报道吗？

如果是的话，那怎么样？

这是我的问题，

提前致谢

i want to split the databse field which is getting displayed on crystal report
means a field on crystal report
like-"xxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxx"
but i wish to print like
"xxxxxxxxxx xxxxxxxxxxxxxxxx
xxxxxxxxxxxxx xxxxxx"


my question is that,when we are dragging database field name on crystal report,which is showing the value on crystal report which is represented by that field in database,that value i want to spit
e.g a address field which can have a large value in side database and when i will drag that address field on crystal report that gone a show that entire address value in a single line like

address
----------------------------------------------
xxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx,xxxxxxxxxxxx
----------------------------------------------
but wish to split that address into more than one line accoerding to the specific length it means i wish to display that address like

address
-----------------------------------------
xxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxx,xxxxxxxxxxxx
-----------------------------------------
is it possible in crystal reports??
if yes,then how??
this is my question,
Thanks in advance

推荐答案

如果我正确理解了这个问题，你需要为报告中的字段定义包装。看看这些说明：水晶报告中的W场Sochinda的博客 [ ^ ]

If I understand the question correctly, you'll need to define wrapping for the field in the report. Have a look at these instructions: Wraping field in crystal report | Sochinda's Blog[^]

这似乎是一个文本对齐问题，检查链接应该可以帮助您解决问题



如何在水晶报告中对齐文本以证明其合理性？ - 堆栈溢出 [ ^ ]

This seems like a text justification problem, check link which should help you in resolving the solution

How to align a text to justified in crystal reports? - Stack Overflow[^]

您需要在查询中将其拆分，以便有两个字段。然后，只需将所需的字段放在报表上。

You'll want to split it in your query so that you have two fields. Then just place the fields however you want on the report.

这篇关于如何将数据库字段的长度拆分为特定宽度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！