• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Displaying alternate content when date field is null

Guest
Nov 16, 2011 Nov 16, 2011

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

TOPICS
Reporting

Views

1.5K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Jun 05, 2012 Jun 05, 2012

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Sep 17, 2013 Sep 17, 2013

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation