如何从标签中删除空白字段 [英] How to remove blank fields from a label
问题描述
嗨朋友，
我创建了一个标签报告，其中包含字段cname，oname，addr1，addr2，addr3，city ，州。
就好像
Praveen
硬件商店
＃34/1，靠近Ram Mandir
第3街区
Rajaji Nagar
操纵
Karnataka
我的问题是如果addr2提交（'3rd block'）是空白的，那么addr3必须自动启动..
赞
Praveen
硬件商店
＃34/1，靠近Ram Mandir
Rajaji Nagar
操纵
卡纳塔克邦
请尽快给我一个解决方案。
我正在使用 Crystal report 8.5
Hi Friend,,
I have created a label report having fields cname,oname,addr1,addr2,addr3,city,state.
It's like
Praveen
Hardware Shop
#34/1,Near Ram Mandir
3rd block
Rajaji Nagar
manipal
Karnataka
My question is if addr2 filed('3rd block') is blank, then the addr3 has to come up automatically..
Like
Praveen
Hardware Shop
#34/1,Near Ram Mandir
Rajaji Nagar
manipal
Karnataka
Please give me a solution as soon as possible.
I am using Crystal report 8.5
推荐答案
我对水晶报告不是很熟悉。但是我可以为你的问题提供一些解决方案。
你可以添加一个地址字段然后绑定组合，而不是添加几个地址字段（addr1，addr2，addr3，city，state）。提交的地址。
例如：我的意思是你只需要3个标签。
cname
oname
地址
然后使用SQL或后面的代码，组合非空字段并绑定到地址字段。
如果值为空，你可以使用公式编辑器来禁止标签
I am not much familiar with crystal report. But I can give you some sort of solution for your problem.
Instead of adding several address fields (addr1,addr2,addr3,city,state) you can add a one address field and then bind the combined address to that filed.
for ex: what I mean is you need only 3 labels.
cname
oname
address
then using the SQL or from the code behind, combine "non empty fields" and bind to the address field.
and also you can use the formula editor to suppress the label if the value is empty
我找到了一个解决方案通过使用IsNull（）... itz为我工作
i found a solution for this by making use of IsNull()... itz worked for me
这篇关于如何从标签中删除空白字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
