Problem Sliding Containers on Report

[VIPPY]

I have a report of just images inside of container fields. The weird thing is, the container field will not slide up if it's empty. So when I print the report, my images show along with a bunch of empty spaces.

Anyone else have this problem and more importantly, how do I fix it?

Also, as another possible work-around if anyone doesn't know how to fix the above, how would I:

Omit Empty fields, particularly container fields.

Thanks.

[IdealData]

I didn't test this but the FMP help definitely allows containers to slide, but if you need to eliminate the empty containers before printing then create a new calculation field:

ContainerContent (type TEXT)

Case (IsEmpty(Container); "empty"; "full")

Then omit the "empty" ones as your last find request.

[John Mark Osborne]

In order for Container fields to slide you have to align them to the top and left of the Container field. You can do this with the Graphic menu item under the Format menu. The Container field is probably currently aligned to center and center which won't slide through an empty field.

[VIPPY]

I didn't test this but the FMP help definitely allows containers to slide, but if you need to eliminate the empty containers before printing then create a new calculation field:

ContainerContent (type TEXT)

Case (IsEmpty(Container); "empty"; "full")

Then omit the "empty" ones as your last find request.

I also read that in the FMP help and even called FM support. FM support was able to reproduce the problem and said they would try to come up with a fix, but they never called me back.

Also, I'm not the best at scripting in FMP, but if I understand correctly, you cannot perform a find on container fields.

Could you explain in more detail how to get your script working. Thanks again.

[VIPPY]

Ok, duh, I figured out how to create the Calculation field... Thank you. Only problem is, I'm trying to do this in-conjunction with my other post:

http://fmforums.com/forum/showtopic.php?tid/176263/

So, how do I do multiple Finds for my scenario?

[IdealData]

You create multiple finds by adding a new request when you are in find mode.

In find mode the clip book behaves as though you were in browse mode, with each find request being shown as different "records" (requests). The last request should use the OMIT check box on the left, just below the clip book

[VIPPY]

Thank you. I have tried this to no avail. I am trying to combine what I learned here with what I learned here:

http://fmforums.com/forum/showtopic.php?tid/176263/

Which is using a variable:

Set Variable [$Search; Value: MYTABLE::FieldA]

Enter Find Mode []

Set Field [MYTABLE::FieldA; $Search]

Perform Find []

So when I try to perform multiple searches, the variable $Search gets parsed exactly as "$Search" instead of the actual variable itself.

So how do I use variables in the "Perform Find" sub section that you mentioned?

[VIPPY]

I was able to figure it out on my own and once I thought about it more, it was actually quite simple:

Go to Layout [ “Assembly” (Main) ]

Set Variable [ $Search; Value:Main::Procedure Number ]

Set Variable [ $Filled; Value:"full" ]

Enter Find Mode [ ]

Go to Layout [ “Report - Picture” (Procedure) ]

Set Field [ Main::Procedure Number; $Search ]

Set Field [ Procedure::PictureCalc; $Filled ]

Perform Find [ ]

Enter Preview Mode

Print [ ]

Enter Browse Mode

Go to Layout [ “Assembly” (Main) ]

I just added another "Set Variable" and "Set Field" to add more criteria to my search. Thanks for your help with the other topics.