Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Copy link to clipboard
Copied
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.