Have 2 results but only need one 1

[bluenet1]

Hello, I have an event that has 2 Child events of which I am trying to pull the date of the only Child event that is showing a date.
How do I achieve getting the date from the Child event with a date?

Thanks in advance for your assistance!!

CRXI

 

[lbass]

Suppress the detail section with:

isnull({table.date})

-LB

 

[bluenet1]

I've done that and it still gives the first of the two results which is null. I am trying to get the second Child event date to show.
I'm also thinking that because I have to show this date in the GH maybe that is causing it to not show.?

 

[lbass]

You didn't explain that. Instead of conditional detail suppression, create a formula like this:

if not isnull({table.date}) then
{table.child}

Then insert a maximum on this at the group level and drag the result into the header. Then suppress the detail section.

-LB

 

[bluenet1]

Thanks lbass, your suggestion worked!