Notices
Welcome to the Blackbaud User Society!

We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.

Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.


Reply
 
LinkBack Thread Tools Display Modes

Old 06-03-2008, 12:51 PM   #1 (permalink)
Junior Member

Join Date: Jun 2008
Posts: 1
Rep Power: 0 Stacey Arnold is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Suppressing blank fields
Hi, I'm using an older version of Crystal Reports, 8.0. I am trying to display the primary address and would like to suppress address lines 2, 3,& 4 if those are blank on certain records. Please advise. Thank!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 06-04-2008, 05:15 AM   #2 (permalink)
Junior Member

Join Date: Oct 2007
Location: Kent
Posts: 2
Rep Power: 0 shirley.bradford is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Information Edge (TIE)

Would this help?

if isnull({MemCnAdrPrf.MemCnAdrPrf_Addrline2}) Then
CStr ({MemCnAdrPrf.MemCnAdrPrf_City} + "
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 06-04-2008, 10:20 AM   #3 (permalink)
Junior Member

Join Date: Apr 2008
Location: Sun Valley, Idaho
Posts: 20
Rep Power: 0 02bnsv is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

You can also create a text block and add the address block fields as text as follows

AddressLine1
AddressLine2
City, State Zip

After doing this, you can right click on the text box, select the format editor and choose 'suppress embedded field blanks".
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
suppressing blank fields

« formula for memberships as of gift date? | Parameter fields in Crystal XI not working »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump



Want to ditch the ads? Donate here!
Cheap Electricity - Credit Cards - Mobile Phone - Credit Cards
All times are GMT -6. The time now is 03:47 AM.

Navigation

Forum Navigation

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64