Jump to content

Problem Sliding Containers on Report


VIPPY

This topic is 6539 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6539 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.