faaslave Posted November 30, 2011 Posted November 30, 2011 I have run into something that doesn't make sense to me. Under layout, when you select printing with two columns and select down instead of across, the columns also affect the sub summary parts. This might have uses but in the report I am trying to make, I want it to only affect the body. I don't see an option to keep the column split in the body only when selecting "down". If you are making a contact list with sub summary fields, you would only want the body to print down in two columns. If I choose across, everything works fine but it doesn't look good and wastes space. If I choose down, it looks fine except the body is going to cut through every section. An across version and a down version is attached. Is there a work around for this? Thanks, Dave across.pdf down.pdf
comment Posted November 30, 2011 Posted November 30, 2011 If I choose down, it looks fine except the body is going to cut through every section. I am not sure what you mean by that. Regarding the sub summary parts, they MUST be the same width as the columns when you select "Down first", because a group may change mid-column (your example shows two such changes on page 3).
faaslave Posted November 30, 2011 Author Posted November 30, 2011 Thanks Comment, That is my question. Why can't I just have the body in two columns without the sub summary parts. Then if the change comes mid-column, it could page break. When printing a contact list, you want to print down. The list is very big, so it is nice to have sub summary groups. I guess I can't have both. I was hoping there was a work around. Dave
comment Posted November 30, 2011 Posted November 30, 2011 Why can't I just have the body in two columns without the sub summary parts. You don't have to have sub-summary parts on your layout. But if you do, and you print down first, they must be the same width as the columns - otherwise it will be one giant mess. if the change comes mid-column, it could page break OK, then why not use the header part for the sub-summary titles? You could make it calculated, so there's one version for starting a new group, and another for "continued".
faaslave Posted November 30, 2011 Author Posted November 30, 2011 OK, then why not use the header part for the sub-summary titles? You could make it calculated, so there's one version for starting a new group, and another for "continued". That sounds perfect. I am not sure how that would work, but I like the sound of it. In the Header I would have a calc field that displayed the correct header using a case statement? I will try and work on that idea. Thanks, Dave
comment Posted November 30, 2011 Posted November 30, 2011 See also: http://fmforums.com/forum/topic/52392-sub-summeries-with-continuing-label/page__p__245909#entry245909
faaslave Posted November 30, 2011 Author Posted November 30, 2011 Thanks Comment. I will give it a try. I appreciate you taking the time to help me. I retire in 9 months, then I might have the time to get better with this program. Dave
faaslave Posted December 2, 2011 Author Posted December 2, 2011 The calc didn't work, Try an unstored calculation field (result is Text) = Case ( City = GetNthRecord ( City ; Get ( RecordNumber ) - 1 ) ; City & " continued" ) but I ended up with a real nice product. I took your advice and kept everything in the header. When I run the script, it goes to the new layout, everything works, and it ends up in preview mode where I want it. The only strange thing is, as usual it does not show how many pages are there, just a ? until you go to the end and back. So in the script I put "Go to Record/Request/Page Last" then "Go to Record/Request/Page First" It still didn't work. What is the trick to make that work? Thanks, Dave
faaslave Posted December 2, 2011 Author Posted December 2, 2011 Figured it out. Not sure if it is the efficient way but I used: after preview mode go to last record get pagenumber back to first enter preview again Dave
comment Posted December 2, 2011 Posted December 2, 2011 The calc didn't work, It seems to work for me. Except that Filemaker interprets a page break as a column break when printing down, so it doesn't look like a good idea overall. WideHeader.zip
faaslave Posted December 4, 2011 Author Posted December 4, 2011 I see what I did wrong now. Very handy calc. I also found out that some of my scripts that work great on my mac, do not work on Windows 7. When my script runs and produces an email with a created exported file, the file isn't in the body when run on windows. It must be something about the file path. First time I have had to deal with a windows computer running this. Dave
Ocean West Posted December 4, 2011 Posted December 4, 2011 Dave not sure if this would work in your situation but here is a technique file I did that gave some benefits of DOWN & ACROSS SD http://fmforums.com/forum/files/file/12-multi-column-printing-faux-down/
faaslave Posted December 4, 2011 Author Posted December 4, 2011 Wow, Thanks. I downloaded it and will take a look at it. I have to figure out this windows issue first. Working on filemaker is just like having a puzzle book handy. I guess that is why I like it. I think I found the part that I need to fix. I assume I need to figure out what path to place in here for windows. Dave
Ocean West Posted December 4, 2011 Posted December 4, 2011 here are two custom functions that may help.. https://github.com/petrowsky/fmpfunctions/blob/master/file.setpath.fmfn https://github.com/petrowsky/fmpfunctions/blob/master/file.ospath.fmfn
faaslave Posted December 4, 2011 Author Posted December 4, 2011 Thanks Stephen. I would think that filemaker would have incorporated this feature with less required on the developers end. I hope the second one you listed is the one I need.
faaslave Posted December 5, 2011 Author Posted December 5, 2011 Thanks for your help Stephen. I don't think I could have done that myself. Dave
Recommended Posts
This topic is 5000 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 accountSign in
Already have an account? Sign in here.
Sign In Now