Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Removing Empty fields Post Reply Post New Topic
Author Message
Rodemusprime
Newbie
Newbie


Joined: 19 Aug 2010
Online Status: Offline
Posts: 10
Quote Rodemusprime Replybullet Topic: Removing Empty fields
     Posted: 22 Sep 2010 at 6:13am
I have a report that is pulling data from an Excel spreadsheet.  It contains 3 columns something like this
 
Number          Phone Number        Description
12324            555-1212               Cardiology
 
 
My problem is alot of records will just have the first 2 columns populated, and nothing for the 3rd.  I would like to omit those records entirely, and just leave me with the records with the Description populated.
 
Any suggestions would be great.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Sep 2010 at 6:21am

in your select expert

NOT (isnull(table.description) or table.description="")
IP IP Logged
Rodemusprime
Newbie
Newbie


Joined: 19 Aug 2010
Online Status: Offline
Posts: 10
Quote Rodemusprime Replybullet Posted: 22 Sep 2010 at 6:26am
Again, DBlank, you are the best.
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.