2 Replies Latest reply: Sep 17, 2013 8:27 AM by Eddie Lotter

Displaying alternate content when date field is null

mnp13 Nov 16, 2011 9:11 AM

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

1. Re: Displaying alternate content when date field is null

jlig Nov 6, 2013 8:37 AM (in response to mnp13)
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"
Like Show 0 Likes (0)

Actions
2. Re: Displaying alternate content when date field is null

Eddie Lotter Sep 17, 2013 8:27 AM (in response to mnp13)

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.
Like Show 0 Likes (0)

Actions

Go to original post

Legend

Correct Answers - 10 points