possible if statement with show/hide other field?

[ry1633]

hello,  I'm wondering if these is even possible in Framework Mgr.  What I'd like to do is have an IF statement where I have an end date, and if that date field is blank,  then to show the IS_ACTIVE = y,  otherwise hide the IS_ACTIVE field?

If
[END_DATE] = null
)
then
(
IS_ACTIVE = 'Y'
)
else
(CAST([END_DATE], DATE)
)

[bdbits]

You don't really show/hide fields in FM. But you can certainly create calculated data items.

For example, perhaps you want IS_ACTIVE as a calculated field along the lines of: if ([END_DATE] is null) then ('Y') else ('N')

[ry1633]

yeah that makes sense - that's a good workaround.  Thanks for steering me in that direction - I wouldn't have thought of that. :)