PLEASE
Someone tell me what silly thing I'm doing that prevents this property from
working on my report.

I have a report for a Construction Engineer - works great!
It displays the Engineers as- Construction Engineer: Tom Brady

The same data is needed for the Manager of the Construction Engineers except
the Manager will drive the report by date rather than by Engineer Code.

If I set the property and there is not data the label is not displayed. HOWEVER,
once I make the field a calculated one so that the name displays and not
the code I can't set the property.

Say it isn't so AND I am doing something dumb!!!!

TIA

Jeanette,

You can accomplish delete when empty on a calculated field, thusly:

iif(isBlank([table.field]),"","Field Label: " + [table.field])

....and use an edit field rather than a labeled field. Then the field
label is part of the calculation and if the table field is blank, the
entire calculated field is blank.

Hope that helps,

Liz


Jeanette wrote:

ELIZABETH!!!

This was so ELEGANT, it was coooooool !

Thanks!

The Mgr wanted a bold Label and then the Name but I will convince the Mgr
it's either ALL bold or All regular font...


Liz McGuire <liz (AT) paradoxcommunity (DOT) com> wrote:

You can also just use two calculated fields on the report, the first one
bold - iif(isBlank([table.field]),"","Field Label: ") -, the second one
regular font - iif(isBlank([table.field]),"", + [table.field]) and group
them together.

On 22-02-2007 14:20 Jeanette wrote the following email:

Jeanette wrote:
If it's cooooool, how come I'm in trouble? :-( (No one ever calls me
Elizabeth unless I'm in trouble.)

What Zal said - just use two calculated fields - you could group them in
a text object to keep them together and positioned right.

Liz