Null Value in Calculated Field

Last post 01-22-2008 10:44 AM by kenjha. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

01-11-2008 6:00 PM

kenjha
Joined on 11-17-2006
Posts 2

Null Value in Calculated Field

Reply Contact

I have a calculated date field in ReportDesigner (Ver 2.5.20072.239) with the following settings:

Text = "IIf(IsNull(Max(dtmComp)),Null,Max(dtmComp))"

Format = "M/d/yy"

This works fine as long as there is a date in the underlying DB field. However, if the DB field is null, the report displays the format string itself ("M/d/yy"). I've also tried making Format blank and adding the format in the Text formula but get the same result. Is there a way to display the field as blank if there is no data?

Filed under: C1ReportDesigner, C1Report

01-18-2008 5:59 AM In reply to

C1_DaveT
Joined on 02-28-2006
Posts 546

Re: Null Value in Calculated Field

Reply Contact

Hello,

In this scenario I would recommend you to keep Format field blank and use following script in text property-

IIf(IsNull(dtmComp),"",Format(Max(dtmComp),"M/d/yy"))

This should resolve the issue.

-Dave Traister.

<kenjha> wrote in message news:201056@10.0.1.98...

I have a calculated date field in ReportDesigner (Ver 2.5.20072.239) with the following settings:

Text = "IIf(IsNull(Max(dtmComp)),Null,Max(dtmComp))"

Format = "M/d/yy"

This works fine as long as there is a date in the underlying DB field. However, if the DB field is null, the report displays the format string itself ("M/d/yy"). I've also tried making Format blank and adding the format in the Text formula but get the same result. Is there a way to display the field as blank if there is no data?

http://helpcentral.componentone.com/cs/forums/p/74022/201056.aspx#201056

01-22-2008 10:44 AM In reply to

kenjha
Joined on 11-17-2006
Posts 2

Re: Null Value in Calculated Field

Reply Contact

Thanks, Dave. That worked!

Page 1 of 1 (3 items)

C1 Community