Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Having A Field Not Come Into Report Post Reply Post New Topic
Author Message
gasmith74
Newbie
Newbie
Avatar

Joined: 11 Sep 2017
Location: United States
Online Status: Offline
Posts: 4
Quote gasmith74 Replybullet Topic: Having A Field Not Come Into Report
    Posted: 08 Nov 2017 at 6:08am
Hello,

My first post to this group and I apologize if this is an elementary question or has been answered somewhere else and I just did not find it.

Basically I am looking for a way, either a selection formula or a field formula, to tell the report that if this one specific field is 0 or null then don't show up in the report.  I only want data in my report that have values in this one field.

I am working with an inventory list of items.  The report works great, but there are a couple of lines of blank data and I am not sure where they are coming from, but I don't want them there.  I don't have access and our IT department sucks to deal with this from the SQL server side of things, so I figured it would be possible to delete them through a formula, but that is what I can now not figure out.

Any help will be appreciated for this probably elementary and Crystal Reports 101 question.

Andy
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Nov 2017 at 6:47am
I think what you want to use is the record select.
You can add conditions there to exclude rows from your data set.
IP IP Logged
gasmith74
Newbie
Newbie
Avatar

Joined: 11 Sep 2017
Location: United States
Online Status: Offline
Posts: 4
Quote gasmith74 Replybullet Posted: 08 Nov 2017 at 7:03am
Great suggestion and I think it worked.

I added a record sort where for a particular field if value is greater than 0.

This wiped off the data I did not want to be in the report and all my other data appears to still be there and my summary count worked as well.

Thanks for the suggestion.

Andy
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.