Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Showing Data only if that field has data. Post Reply Post New Topic
Author Message
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Topic: Showing Data only if that field has data.
     Posted: 11 Jan 2011 at 3:01am
Hello
 
I'm designing a report and pulling data from 8 fields from an AP Payables  table. One of the fields is a "contract number" field. I'm wanting to only see data  from all 8 fields if the "contract field" has string data in it.
 
I'm grouping by Vendor
 
thanks
Rick
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2011 at 3:56am
in your select expert
Not(isnull(contractnumberfield))
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 11 Jan 2011 at 6:21am
hello
 
that worked and only shows if there is data, but shows all the other entries too where the field is null, but doesn't show the data.
 
 
Rick
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2011 at 6:28am

sorry not following you.

are you talking multiple tables? Can you give example data of wht you are getting and what you want to get?
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 11 Jan 2011 at 6:33am
Hey.
 
 
It is just one table. Pulling 8 fields from that table.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2011 at 6:43am
What exactly is it doing that you do not want it to do. Maybe a couple of sample rows of fake data?

Edited by DBlank - 11 Jan 2011 at 6:43am
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 11 Jan 2011 at 8:19am
Hey
 
here is what is showing.
 

85

88

94

109

080530109

116

131

 

The bold numbers are vendor numbers. The data showing is the contract number but it is showing lines where data is but it is not showing it because the filed is null for those vendors.

If you can send me an email to rrushing@djcon.com , I can reply to you a copy of the report.
thx
Rick
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Jan 2011 at 8:59am
sorry, can't accept outside files.
So you are gouping on vendor
your detail section is contractnumbers
you have vendors that have no contract numbers and you want to exclude them.
Alter your select statment to
Not(isnull(contractnumberfield) or contractnumberfield="")
IP IP Logged
RRushing
Newbie
Newbie
Avatar

Joined: 10 Jan 2011
Location: United States
Online Status: Offline
Posts: 14
Quote RRushing Replybullet Posted: 11 Jan 2011 at 9:57am
Smile
D-
 
that worked. Thanks a bunch.
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 | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.