Skip to main content
A
Anonymous
November 16, 2011
Question

Displaying alternate content when date field is null

  • November 16, 2011
  • 2 replies
  • 1573 views

I am using Report Builder 8.

I am grouping on a date field, but some of the people returned have a null value. I need to show an alternate heading if that group's date is null, I would actually like it to head it with "No Date"

However, I can not figure out how/where to put it that conditional statement.

Thanks!

Michelle

This topic has been closed for replies.

2 replies

EddieLotter
EddieLotter
Inspiring
September 17, 2013

A simple solution is to use an expression field in your header, something like the following:

iif( isdate(DateField), dateFormat(DateField,"m/d/yyyy"), de("No Date") )

I did not test the syntax, this is purely an example.

J
jlig
Inspiring
June 5, 2012

Michelle, not sure if this answers your question..but in the image below..

  • I use a conditional "label" field under the "Code" column
  • That prints only when the: query.wkRptCd IS 'CAI'
  • Notice my "Print When Condition"

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices