Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Not excluding blank data Post Reply Post New Topic
Author Message
El22
Newbie
Newbie
Avatar

Joined: 07 Apr 2011
Online Status: Offline
Posts: 10
Quote El22 Replybullet Topic: Not excluding blank data
    Posted: 13 Apr 2011 at 10:18pm
Hello,
 
I am new to Crystal, so this may be a simple problem I am having.
 
I want to run reports in my company on every time a comment is left in any of our customers accounts, by a specific person in a specific date range. Obviously inputting all of these conditions into the select expert does not include null fields, i.e. accounts which do not have any comments in at all or have comments outside of the date range I am specifying.
 
What I want to get to is every account being included and classified but want to try to avoid having to run every single comment ever left in a set of accounts - I just know there must be a quicker way.
 
Any advice on this? Thanks in advance.
 
E
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Apr 2011 at 5:57am
In addition to checking for the specific people and date range, you have to also check for null values.  So, you need to edit your selection formula.  It's very important to watch where your parentheses are here or else it won't work properly.  It will look something like this:
 
(IsNull({notestable.datefield}) or
({notestable.person} = {?Person Param} and
  {notestable.datefield} >= {?StartDateParam} and
  {notestable.datefield} <= {?EndDateParam}))
 
You MUST check for null first or else this won't work!
 
-Dell
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.