Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Excluding fields Post Reply Post New Topic
Author Message
db3712
Groupie
Groupie
Avatar

Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Quote db3712 Replybullet Topic: Excluding fields
    Posted: 25 Jan 2010 at 1:47pm
I have a date field.  Lets call it z_udf_date.  I want to pull that date regardless if it is populated or empty from the start of the current month to the current date with the ability to rollover next month so it starts over on Feb 1.  I also want to pull that field if it is empty prior to the current month.  Does anyone have any ideas?  Thank you ahead of time.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 25 Jan 2010 at 2:07pm
If the field is empty (I am assuming it will be considered a null value).  Thus if you do a isnull check on in a formula, then you can set it to a value that could be suppressed (providing you do not want to display that value).  It really depends what you want to do if it is a null values.
IP IP Logged
db3712
Groupie
Groupie
Avatar

Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Quote db3712 Replybullet Posted: 25 Jan 2010 at 3:14pm
So far I have {invoice_head.z_udf_date_1}=MonthToDate which bring up all dates starting Jan 1 to current.  I now need to add all previous months prior to Jan 1 if that field is empty.  Do you know how I incorporate that into my current formula?  Thanks!
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.027 seconds.