This should easy but I'm stuck. I've read and re-read the missing
manual but I can't find how to do this.

I'm using filemaker 8.5.

Basically, I want to hide field labels (and the fields themselves) in
reports that have no data attached to them. It sounds like a "sliding"
function, but it's more like "hiding".

Example:

(label) Title
(field XXXXXXXXX

(label) Author
(field [no data]

(label) Publisher
(field YYYYYYY

On the report, I want it to look like:

(label) Title
(field) XXXXXXXXXXX

(label) Publisher
(field) YYYYYYYYY

Is this a scripting scenario or am I missing something really easy
here?

Thanks in advance.

R Kelly

"bowriter" <robertekelly (AT) gmail (DOT) com> schreef in bericht
news:1178489652.439955.246720 (AT) u30g2000hsc (DOT) googlegroups.com...
no, it is not easy, it simply can not be done. There are ways to fake it,
but your field will just be hidden from view not just missing and then
sliding. If you want that you have to create a calc for every field which
results into 1 when there is data in the field , a constant 1, and a
relation from the constant to the calc. Then draw a portal over the field
using this relation. The field will be hidden from view when empty. But
there is no easy way to make it visible again so the user might enter data.
You could also build as many layouts as you need and script the 'goto' .

Keep well, Ursus

In article <1178489652.439955.246720 (AT) u30g2000hsc (DOT) googlegroups.com>,
bowriter <robertekelly (AT) gmail (DOT) com> wrote:

For a printed report (or one to be viewed in Preview mode) this is
fairly easy.

Sliding is exactly what you want, but you'll also need at least one
extra Calculation field.

If the above example is for one record, and the report has multiple
records, then all you really need is one Calculation field that brings
together the text needed on the report using If statments and the
concatenation (&) function.
eg. Something like:

ReportField Calculation, Unstored, Text Result
= If (IsEmpty(Title), "", "Title{rt}" & Title & "{rt}{rt}")
& If (IsEmpty(Author), "", "Author{rt}" & Author & "{rt}{rt}")
& If (IsEmpty(Publisher), "", "Publisher{rt} & Publisher)

where {rt} is the Return symbol (the "backwards P" on one of the
buttons in the Define Calculation window).

This assumes any of the fields may be empty and therefore the field and
label is not wanted.

Put this one field onto the Layout instead of all the separate labels
and fields. Set this field (and any objects below it in the same Layout
Part) to Slide Up AND Reduce Size of Enclosing Part.


Note: That's a quick untested Calculation. It propbably needs a little
tweaking to remove extra unneeded {rt} characters, but it is the
general idea. Sorry, I'm a bit rushed today. (





Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On May 6, 9:04 pm, Helpful Harry <helpful_ha... (AT) nom (DOT) de.plume.com>
wrote:

No problem! Thanks for the advice--I'll try it!