Print Page | Close Window

Having A Field Not Come Into Report 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=22495 Printed Date: 28 Apr 2024 at 6:58am Topic: Having A Field Not Come Into Report Posted By: gasmith74 Subject: Having A Field Not Come Into Report Date 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 Replies: Posted By: DBlank Date 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. Posted By: gasmith74 Date 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

Print Page | Close Window