Report - Cataloug with product picture

[Glenn67]

Need to print a product Cataloug, but only using the records who have image in the container. I Can not find the solution to sort the records.

Any solutions?

Regards

Glenn P.

[comment]

Define a calculation field (result is Text) =

YourContainerField

Search this field for * (wildcard) to find records that have anything in the container field.

[Glenn67]

Nice!

Can I then use this text box for a script, if I need to print the catalogue with all records, but not showing empty boxes (container fields).

Like: if (*) hide ContainerField, this script are running on each records.

[bcooney]

Just to be clear, you cannot use this calc field to "hide" container fields with an IF construct in a script. Comment suggested to FIND using a wildcard. Only records that have a non-empty container will have a value in the calc field and will be found. All empty container records will be omitted (if that's what you mean by "hidden").

[comment]

to print the catalogue with all records, but not showing empty boxes

See if this helps:

http://www.filemaker...62.html#1030089