Customer Address Display
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3156
Printed Date: 05 May 2024 at 7:32am
Topic: Customer Address Display
Posted By: Elisha83
Subject: Customer Address Display
Date Posted: 12 May 2008 at 3:10am
|
Address 1 -> line 1 Address 2 -> line 2 Address 3 -> line 3 Address 4 -> line 4
Zip Code, City, Country -> line 5
Refer to the example above, I need a help on this. My problem is when Address 4 is an empty data, it will create a gap between Address 3 and Zip Code, City, country line. How can I make it to eliminate the gap and during the info display, the Zip code, City, Country will be display directly after the Address 3. Can anyone guide me on this?
Thanks~
 ------------- 3Lish@ |
Replies:
Posted By: solent
Date Posted: 12 May 2008 at 3:52am
|
Hi, Modify the report and Insert a Text Object. Place the address fields in this Text Box.
Click on the Text Objects and choose Format Text.
Check the option that says Surpress Embedded Blank Field Lines and this should work.
Hope this helps |
Posted By: hilfy
Date Posted: 12 May 2008 at 10:22am
|
Another way to do it is to create a separate section for each line of the address and then turn on "Suppress If Blank" for each section.
-Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |
Posted By: Elisha83
Date Posted: 12 May 2008 at 7:12pm
|
Hi Solent~ Thanks for the solution that you give. It works well..  ------------- 3Lish@ |
Posted By: Elisha83
Date Posted: 12 May 2008 at 7:28pm
|
Hi Hilfy,
The solutions you mentioned, I don't really understand. Do you mind to explain more detail on it? Just another reference for me.
What I do at first is I drag the address field arrange like what I shown in my example above. Then I right click the "Address 3" field, go to format field, next to the suppress option got a formula icon. Then I click in and write a formula Address 3 ="" or Isnull(Address 3). But it wont suppress the empty field.
Thanks~  ------------- 3Lish@ |
Posted By: Lugh
Date Posted: 13 May 2008 at 4:19am
|
Hilfy's solution involves creating multiple detail sections. In design view, right-click on the Details section, and select "Insert Section Below". You will now have Details A and Details B. If you do this a couple more times, you can have a separate Details section for each line of your address. Put one of your address fields in each details section. In the Section Expert, toggle the "Suppress Blank Section" option on. One potential downside to this approach is that it suppresses the entire line. Depending on your report, this may not be a big issue. But, many reports have information to one side of the address, which makes this option less viable. |
Posted By: Elisha83
Date Posted: 15 May 2008 at 3:20am
Thanks Lugh for the explanation~ Now I understand already. Thanks a lot~ ------------- 3Lish@ |