Skip navigation
Currently Being Moderated

Displaying alternate content when date field is null

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

 
Replies
  • Currently Being Moderated
    Nov 6, 2013 8:37 AM   in reply 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"

     

    ColdFusionReport_conditional_fields.jpg

     
    |
    Mark as:
  • Currently Being Moderated
    Sep 17, 2013 8:27 AM   in reply 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.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points