Howdy.
Have a report that in addition to a table frame containing the active
records it also contains another table frame within a box containing
the inactive records. The tables are linked via the data model.

If there are no inactive records, the table frame is not displayed.
However, the text box containing the box's title, e.g. Inactive
accounts with balances and totals text box are displayed. The box has
no property allowing me to delete if empty, etc. Nor are there any
events available other than report open and close.

How can I make the box invisible if inactive record count is 0 similar
to a form where a frame can be made visible so as to "hide" the objects
behind it? I could also be too close to the problem and not see a
workaround/solution.

Thanks in advance,
Rey

Try making it a calculated field with an iif instead.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits
since 1982

Howdy, Dennis.
Thanks for the suggestion.
Added this to the box and now it "explains" why there is no data in the
box. I'd tried doing a nested IIF inside the name formula but it wasn't
working.

Got to remember to step back, take a walk/do something else and then
return to the issue 8-)

Thanks again,
Rey

"Rey" <reycollazo (AT) cox (DOT) net> wrote:
Rey,

If you changet your box's title from a Text object to an Calculated Field
object, you can probably get the entire box to disappear. No point having
'this space intentionally blank' (unless you are IBM).

Delete the current title, and add a Field that has a calculated field that
returns a blank value if there are no records to show.

Thanks,
Jim Moseley

Howdy, Jim.
Thanks for the suggestion.

This is what I initially thought Dennis had suggested - but hadn't
tried - as I just added an undefined field object with the formula
below.
IIF([STATUS.AssnNumFK] <> Min([:PRIV:INACTDET.AssnNumFK]), "NO INACTIVE
ACCOUNTS FOR THIS ASSOCIATION", "")

Now, with your suggestion, I went back and tried it - placing table
frame inside the field with other calculated fields but no text - and
it worked. However, now am not able to display the field frame thus
simulating a box effect. Even tried shadow - no workee.

But it is a neat trick/tip.

Thanks again,
Rey

Rey
<<
However, now am not able to display the field frame thus
simulating a box effect.
If you can't make the field frame to show, the tableframe is probably to
close to the field frame. Insert a space here and there.
--
Bertil Isberg
CTECH
Paradox Buglist: http://hem.bredband.net/bertilisberg/

remove spamfilter (reversed) to reply