Displaying alternate content when date field is null

[Guest]

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

[jlig]

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"

[EddieLotter]

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.