conditional fields in a report?

[mcgraw]

Is it possible to have a field only show in a report if it is not null?

I have a report that I want to show the closed_dt field, only if a system has been closed. For all open issues, I don't want to have the field show at all.

Just wondering 1: if this is possible, and 2: if anyone has any examples so I can learn how to do this!

Thanks!

 

[HiTechCoach]

Yes it is possible to do.

In the On Format event for the section with the control use something like:

Me.[b]txtclosed_dt[/b].Visible = IsDate(Me.[b]txtclosed_dt[/b])

This assumes that the field closed_dt in bound to the text box named txtclosed_dt