Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: CrystalReports
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
Posted 9-Jan-13 20:55pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

i found a solution for this by making use of IsNull()... itz worked for me
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 6,249
1 Sergey Alexandrovich Kryukov 5,680
2 CPallini 4,850
3 George Jonsson 3,454
4 Gihan Liyanage 2,522


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 13 Jun 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100