Printing

Is there a way to place vertical text (the same text) at the side of every printed page. Something like the attached image.

Hello, I am trying to design a form layout that would easily print on pdf on a A4 format. My idea was that as long as I respect the aspect ratio of the A4 (1.414) on the body size of my layout, I would be able to export to pdf as is and Filemaker would scale to fit the layout on the A4 pdf page. Turns out it doesn't seem to work like that: - It always adds the margin for printer which I don't really need, if a user wants to print, he would print the outputted pdf not straight from filemaker. - it doesn't print the full layout but limit itself to a portion of the layout (ie 842 * 595 points minus the margins) from what I understand. …

I have labels (for books) that I print out, based on a text field which contains the book details. To properly do this, the name of the book needs to be italicised. But a very strange thing happens. Whatever font I put the field in, the italicised section just reverts to some kind of system font (I guess), doesnt matter what font I change it to. And it also changes the line spacing, for the italicised section. This occurs in preview, and when printing. I have no idea what is going on, or what to do about it. See attached:

Hi all using Filemaker Advanced 18. I have a single table with 100 records. called scenes. Each record has a reel number. So records 1-10 have a reel number of one. And then go to reel 2 and so on. I don't understand the way to summarize to get a page break. Basically I want the page to break when the reel number changes. I would be grateful for a bit of help even though it is a basic task. Thanks...

I'm not sure if this is do-able, but I thought I'd ask. We print a lot of labels for equipment and hit upon the idea that for smaller devices like iPad power supplies, if we could print two records per label then we could slice the labels down the middle and save money to boot. (See attachment for format-- it's in Layout mode) The problem is that with a label printer, each label is a page/record. Is there a way to print labels so there are not two of the same names/records per label but different names on each "half" of the label, i.e., if we have a list of ten people, five labels would print with a (different) name per each half of the label?

Hi I have a database that generates a report across a selection of dates, showing what scenes are to be filmed on each date. I recently added in the scene layout the two fields - Year set in and INT/EXT, however when I ask it to generate a report it will repeat these two fields on every date with the number input in the first record. None of the other fields do this. The fields are in the same 'scenes' table as all the other fields used in the report. I have added fields before and this has never happened. I have tried to see what is different, but the set up for both fields seems to the same as all the others. if you are in the scenes layout and go…

Howdy, howdy: I'm curious if there's a cheat where FMP will create reports where the sub-summary sections can run the width of a page but the Body section would print in columns; it would make some of my reports much more visually pleasing. TIA for your help, Rich

Hi all, I am constuffulated trying to find why a particular text field will not print its contents. The contents are visible in both Layout and Browse mode and the Object Visibility is NOT selected to hide when printing. There is no Conditional Formatting applied and the "Hide Object When" condition is not activated. I have placed a duplicate of the field in the header and the data shows there for the selected record but it does not show in the body. The second screenshot is Browse Mode and the third is Preview Any help appreciated

I have a sub summary part that appears on top of the body that does not print. The sub summary part appears properly (with the proper data) in browse and preview mode. In preview mode, if I save to pdf, the sub summary part appears correctly in the pdf. When I print it.... nothing. I believe it has something to do with th FM print.... I am doing everything through a script. I stopped the script and changes a bunch of setting... changed printers.. changed back... no clue what... and it actually printed. But.... when I closed that window... back to nothing. Any ideas?

Hello Board. I may be searching the incorrect terms; but I can't find an answer to my problem. I have built a system, it's running on FMS18 and multiple client users access it throughout the day. One part of the system is a quality check screen at a physical bench/station - items are scanned and labels are printed out as required, records are created and used elsewhere. There are three label formats. Each station has three label printers - Citizen 631's. They are networked printers. I would like to have more than two bench/stations operating this process in the future. Can someone point me in the direction of information that would help me to ensure th…

Hi all, Filemaker Pro 11, Mac OS 10.12. 3 computers (not running 10.12) with no problems (knocking on wood). Just set up a computer for a new user. Wanting to avoid any major issues, I limited their access to only a couple fields for their data entry duties. When trying to print multiple records, using the "Records being browsed" selection in the print window, only the current record prints. If I select Current Record, it works as expected- only the current record prints. Pages to print selection is "all". Didn't see anything else that was obviously wrong. Reloaded the print driver and still get the same thing. Logged on using the admin user name…

We have containers that we drag and drop PDFs into, that are externally stored and the field on the layout is formatted as a PDF. I know I've done this in the past where I wrote a little script that sets a temporary path and when it's clicked the enduser can view in Adobe. The script is simple: it sets the a variable to a temporary path, then exports the field contents to automatically open. I cannot get the script to work. It seems so simple... maybe my mind isn't working right today. So my next idea was to make popover button with the pdf container in, interactive so when the user clicks on the popover you see the PDF within Filemaker, that does not work either. I …

With some expert assistance from this forum I was able to get my FMP 17 program to print out external PDFs. Unfortunately, it currently stops with the Acrobat print display open, and I have to manually press Print. (the original discussion was here: Is there any way to have FMP tell Adobe Acrobat DC to automatically print (no human interaction)? And a related issue, but of less importance: Is there any way to have FMP set up the printer (page size, color, etc)? This currently uses Acrobat DC, but there's no particular reason why it couldn't use Preview or Acrobat Reader, if that helps. As I mentioned in the prior post, I know very little about Apple…

I'm running FMP 17 Adv on Catalina. I have a folder containing the FileMaker file and a large number of PDFs. A script determines if there is a PDF for a particular client, and either sends an email with the PDF attached to that client, or prints out the email body and the PDF. The PDF has a known filename, and can be input as an external file or via a container. The filename is available as a $$ variable; the path is the same as the Filemaker file itself. The email part works fine. The problem is in printing. The script prints out the body of the email perfectly, but I cannot get it to automatically print out the PDF. I have Acrobat and Acrobat Reader …

I'm trying to adjust the print scale on a layout so that I can print more data. I've looked at the Filemaker help and it says. I'm on a Windows XP box using FMP 9 advanced. When I open the print setup dialog there is no scale option to adjust. The techs at my office have tried different printer drivers. The two printers that I have available are a HP 4200 and a HP 5550 laser printers. The techs have tried the latest drivers both the PCL version and the Postscript version. And nothing works. Can anyone tell me why I'm not seeing the scale option in the print setup? I'm a long time filemaker pro user and developer and this one has me baffled. I can'…

Hi Everyone, So here's one that's either really easy and I've missed it, or it can't be done! I'm printing address labels, and the 7 rows that I'd like to print take up the whole label layout, and so the first one is located at the top of the label in the layout, and the bottom one is at the bottom of the layout. If the label only has 4 rows, then those 4 rows are printed at the very top of the label. To make things pretty, I'd like to have them centered within the label. Is it possible to have the block of text center itself, so that there is the same amount of blank space both above and below it, rather than having all of the space below it? Many th…

Hello all, New FM 17 user here and trying to figure out how to print PDFs. I have a database with information about advertisers in a publication that I produce. Each record has a field where I have input their current advertisement (a PDF or JPG) and optimized for Interactive Content. I'd like to be able to print a standard letter to each advertiser on one page and their current ad on the next, but when I preview the printout it only shows the standard AdobePDF thumbnail with the filename instead of the actual ad. Is there any way to do this effectively? Thanks!

I know I've solved this before but can for the life of me recall how. I'm printing a sub-summary report, all good, but between the final record on a page and the Footer is a blank band of whitespace that goes unfilled because it's not large enough to fit the next record. I just want it to be the same color as the footer section. Can someone remind me how?

Is there a way to tell FileMaker to bypass/ignore the current default pdf viewer ( Adobe ) and use the default PDF viewer ( Preview ) that came with thier machine ( mac ) ? We do not require any level of sophistication with a pdf viewer other than the required ability to print the pdf. For some reason the clients default Adobe pdf viewer is erroring with a corrupt file message. Thank you. Mr. Ignoramus

i think I need another calc or summary. All I want is the percent of the Type to the overall count on the report layout. it is simple report like the attached. Untitled.fmp12

I'm attempting to re-create some existing "paper" business forms in FileMaker, and have run into a bit of a challenge on how to set the forms up. I have attached a mock-up of a similar type of form, and how I'm envisioning the database structure and data-entry layout looking. Here's where I'm stuck-- If there are more than 2 involved people or more than 2 witnesses, additional pages are required. In this example, there is 1 injured person and 3 witnesses, therefore 2 pages are required. On the first page is the 1 injured person, the details, incident codes, and my first 2 witnesses. On the second page is witness 3 - involved person, details and codes are …

Hello, I hope someone can bring light to the dark where I am at the moment with what seemed to be a simple script... So what I am trying to achieve is to print at once all open invoices from a current customer (in this case only 2 out of 3 invoices), so my script looks like this: Tables: ACT = Accounts INV= Invoices INL = Invoice Line Relationships: ACT (___ACT) = act_INV(__f_ACT) then I have from act_INV (___INV) = act_inv_INL (__f_INV) From Accounts Layout I have a portal that shows all invoices related to that account, and there I have placed a button with the follwoing script: Layout for the print: Print Unpaid invoice…

I have a client who uses a report of many records. Some of the records could have an image appear before the record's details. Occasionally, depending on the length of the descriptions in the previous records, the image will be split across pages. Turning off "Allow part to break across page boundaries" does solve this problem, but has the unwanted side-effect of producing large amounts of whitespace when it's not needed to prevent this issue. So far the only inkling of a solution I've come up with is to check the report one record at a time, temporarily emptying out the description, adding the next record, see if that record has an image and then see if adding that …

Hello I have a situation where I need the page to be set at A5. The output of the report should be on A5. But the printed document should be two of the same page on an A4. It should be two pages per sheet, or two copies on an A4. Any idea how to accomplish this within FileMaker?

Hi, Can anybody help me and explain why I get the "Missing File - Error 100" when I walk through these script steps. I use to stop after step 1, but I had to add some additional work so I created a separate layout off screen ... did what I needed to do, save the record as pdf, set my global field and I closed the window. The refresh is not suppose to be there ... so I attempt to export my "Search PDF Container" field and I get the "fille missing" error. What I can't export a global field What is driving me nuts is I can opt into automatically open the file in step one, but the minute I close the window to finish the script the pdf goes behind the mai…

A few years ago I created an FMP 11 app for my Wife. She is the calendar person for her Children's Hospital Auxiliary Thrift Shop. The app selects a monthly layout, which she fill in, than sends it to a print shop who provides her with copies to be distributed to members pf the Auxiliary. Yesterday, for no apparent reason, the app began printing multiple pages for what should be a single page document. Since my Mac has FMP 14, I had to convert the file is that I could attempt to fix the problem. No such luck. Please open at the attached file then click on the GO button. This will take you to the problem page You should see a single page. Checking in layout mode, you…

Hi, everytime we print and the print module pops ( Mac ) when get this pop up. The only issue is, we have several soluiton in other companies and this "Ram" continues to show up regardless who we are hosting the file with. Can anybody help me here with understanding ... and can were stop it, change it ??? Is there a way to default to someother name other than "RamDigital (DT43)pdf". This was the 1st company we got and ever since then we have had no luck in finding a way to change the name or removing it. Any suggestion would be gratefu. Thank you.

Hello I am having trouble on printing a layout on a dot matrix printer Epson FX-890 with FileMaker16. The database runs on a server. The page is setup in "Letter" format but FileMaker interprets the width smaller than 216mm resulting in starting a new page. In preview mode it shows the truncated page (sth like 140mm x 279mm), if I change the paper format to "Letter fanfold" it shows correctly in Preview but still prints as if the width is 140mm. I tried various drivers for the printer to no successful result. The same layout printed correctly before on FileMaker11 on the same computer, the only difference is that FileMaker11 didn't run from server. Co…

Hi, I want to print labels with a logo in a container field. The text is fine but the logo does not appear in the label. If I change the container field by logo.png and print the lable both the text and the logo appear correctly. Why the logo in the container field does not appear on the label and without the container field if it appears on the label? I use a Dymo 450 Turbo printer Thanks

Hi, I have a customer who needs to modify the sub summary totals independantly of each other ... This report is sorted by Item ID ... Item 1 = $100.00 ( subsummary ) Item 2 = $200.00 ( subsummary ) customer want to manipulate ( discount by 5%) on this subsummary total Item 3 = $300.00 ( subsummary ) Item 4 = $400.00 ( subsummary ) customer want to manipulate ( mark up by 25%) on this subsummary total Item 5 = $500.00 ( subsummary ) I've provided for these markup and discount calculation in the grand total but they do not want their customers to see the discount and or markup on the total So I put the discount / mark up on the l…

Good Morning, I need help trying to create this report as I can not figure out the best method of doing this. Here is what I need the report to do. My report is a sorted list of technology assets by location name. In each sub summary I need to list the count of all different types of devices. The device types are a value list which has all the items such as “Desktop, Laptop, Firewall, Cellphone” in the list. How can I get the totals for each location of each of these devices to appear? Please see the image below for an idea of what I am talking about. Thank you in advance for your help!

Hi All, We're using an application made with FileMaker Pro. We often print from it. We'd like to print with certain settings and not have the printer options dialog box appear each time. I'm assuming this is a file maker pro setting not a windows one. Or maybe one would change something in both a global windows place, and in filemaker pro.. How would I do this? Thanks!!

Dear All, I would like seek for your help on my current situation. I had PC laptop running Filemaker Pro 15 with a Duplex printer. In my solution i had create 21, first layout will be consist of a field and print button. As of the rest of 20 layouts which i had set the field in different location ( randomly ). My intention is to have duplex printing all the 20 layouts in one single print job. How can do that with one single button? Thank you in advance.

Good morning everyone I'm creating a database where I have to print a report. I created the whole structure but I'm at a block. The report is on several pages and I do not find the solution to be able to have at the bottom of each page the subtotal. The section is inserted, in fact at the end of the list I find the result. But if the list is longer than a page, I do not have the data of the subtotal but I find it on the second page at the end of the list. I tried to change the field settings by setting total progressive in the options and inserting it in the footer section but I always find the total integer, while if I look at the data in the table format …

Starting a new project in FMP 14. I have designed a report with title header and a page header. When I view the page in Browse the headers do not show, nor do they appear in a printout. I have attached a file and the layout in question is #4. Can someone give me a clue here, please? Distribution Grids.fmp12.zip

I have a problem making data appear at the bottom of the last page of a multi-page print. For example I have to print a 2 page invoice with the summary data at the bottom of the last page, fix position of summary to match with paper. I try to use Grand Trailing Summary part but the information will not appear at the position of the page and use Footer, show at the bottom of all page, also produces the wrong result. Could you have any suggestions? That appear from FMP Th is is I need to appear ( I print it to pdf and delete the part that I do not want to appear) PS. I use FMP16 on Windows10 Thanks, Pat

Hey Guys, Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue) My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.

Running Filemaker Pro 11 and Filemaker Pro 11 Advanced under Windows 10 in compatibility mode for Windows 7. A customer has purchased a new HP LaserJet MSP426FPW that would not print reports from a filemaker solution I call MarinaPro. Everything works well on other customers Windows 10 computers connected to several different but older HP LaserJet printers. I found that the "Print" commands (Restore & No Dialog is set) within virtually all my associated scripts were set to a an HP LaserJet 4L printer I used at one time when creating solutions and that was moved to the trash heap several years ago. By clicking the print options "Specify" button, I had to se…

I have a database, which has two printable forms. One has been designed in portrait, and the other in landscape. Both of them are only ever printed using buttons tied to script steps, never manually. I was hoping that there would be some way to specify orientation via the script. However, after some poking around of my own and light Google searching I am thinking this may not be so easy. I am able to go into Print setup to change the orientation just fine, however this sets it for the entire database which is not all around helpful. While specifying the options in the print step, I am able to change orientation. For some reason though, this changes the default orientat…

I'm designing an application in which the user has to answer lots of questions (about 180). I want to show the user just one question at a time and control the flow based on prior answers. My current solution is to use a table with generic fields (e.g. Question, Answer, Number) and then use a related command table to move from question to question by changing the number of the question. This works great to present the questions to the user and collect their answers, the problem is that since the fields are generic when I later want to use the data I have to parse it out by, for example, going to the questions table, look for the question number that corresponds to the …

I have to make a thing on filemaker for a school assignment which is be due tomorrow and there are some things i have no clue how to achieve. My assessment notification says "Create a query which shows all sales made during a set period of time. E.g.: last month. Sort the records in descending order based on purchase amount (in dollars)." but i dont know how to do this. Ive tried following tutorials but all i get is error messages. Please, someone, can i have something i can copy and paste into the button criteria thing so im not completely screwed. thanks - A desperate teenager with no clue how to use filemaker

(I'm sure this has been covered here at quite a few times but my search criteria isn't pulling up what I'm looking for so my apologies if my ineptness is showing.) I have a FileMaker Pro database that's a 12-question questionnaire: in one table it has 24 fields; 12 to capture a rating value (one rating field per question) and a companion Comments field for each question/rating; there are around 1,200 records. What I want to do is print a report where each break field is a question and its respective comments--gathered from all the records for that question--falls under its respective heading/break field, sub-summary-style. At first I thought of looping each comm…

Hello! I have a report setup with a sub summary sort, and it works great. When I go to print the report, I would like the sub summary row to print at the top of each page - is this doable? I already have it set to do a page break after each section, but if the pages get mixed up, there would be no way to tell what sub section they belong to. Any and all help is appreciated. Thanks! Using Filemaker Pro 15 Advanced on a Mac

Hello , im having problem with filemaker when i try to print an invoice ... i usually press print button and then filemaker ask for printer and then prints, but now when i press "print" filemaker ask for printer and then it shows me the invoice in pdf.. it does not print .. i have to type command P to print that pdf. here i attached my script steps my script use to works fine but now i don't know whats happening.

Hey all; I'm working with a client who has a multi-file .fmp12 solution. Every time she attempts to print from one specific file, it prints out in B&W, despite her selection of colour from the printer drivers. Printing from other .fmp12 files is fine, and printing from other applications is fine too though. I've gone through all of the Preferences and File Options, and couldn't find anything that fit the bill, so I went so far as creating a clone of that file, and resetting the print setup options... still to no avail. Has anyone else experienced anything similar? Got any suggestions on what else I could try? Also, when we first go into Print Se…

I have a filemaker solution that is used to print out invoices. For the last few years, the invoices have been printed on pre-made triplicate forms on a dot matrix printer. This was slow, unreliable, and has caused a lot of headaches, so the company recently invested in a laser printer that prints and staple 3-part carbonless forms. The problem is that for the stapling to work, the print job needs to be sent as one 3-page document (not 3 copies of 1 page). My initial thought was to append to a pdf and then print that, but from what I read, Filemaker won't print multipage PDFs from container fields. The FM server is run on a mac, but all the clients are on windows 7 o…

Hi forum I have a form which prints fine. There is one form per record but now it has grown and is over a page. I want to make the layout taller but have it print onto next page. Do I need to create a new list report or can a form view print onto two pages? I am home and do not have printer to test it and be concerned if different printers used or print to pdf also so I seek experienced programmers input. It might be impossible.

Hi All, I've been away from FileMaker for a while and just recently came back for a personal project. This means I'm using FM 11, which is pretty old now... Anyway! I have a layout with a picture as a background and I'd like to have a graphic slide up based on the text merge field above it, but it doesn't want to slide because of the graphic it's sitting on. Is there a way to have an object ignore a background object for sliding?

Hey gang, Dealing with a little quirky report part issue in FileMaker. I am wondering how other developers deal with this. Below is the use case scenario and attached is a sample file I zapped up. ISSUE: I have a simple List Report (Header, Body, Trailing Grand Summary, and Footer). Sometimes, depending on the quantity of records in the found set, the Trailing Grand Summary breaks to a new page with NO BODY ROWS. This is quite confusing to the recipient. It would be nice to have at least one row present in this case for continuity purposes. I am wonder if someone has a slick way to cause that last record to push to the next page if the Trailing Grand Summary is goi…

Hello Admin, Can you please fix below link http://www.fmforums.com/forum/showpost.php?post/203220/ Thanks

Being an ignoramus ... I have been trying to read and understand Filemaker's "Sub Summary" guide lines as well as videos, I am unable to figure out how to put my summary totals for my "Part" at the bottom verses were they are now, at the top of the "Part", hmm ? I have no issues with my "Trailing Grand Summary" part. Please see pic. Any assistance I would be grateful. Thank you. Tom :-)

I have a layout in which I have specified 3 columns and printing down in layout set-up. I also have two sub-summary parts and a body on this layout. The first leading sub-summary is defined to page break before each occurrence. When I preview the report it does not page break but rather starts a new column. Is this the correct behavior? If it is, it does not seem right and does anyone know how to get it to page break with the printing down option?

I have a list view with several records in a found set. TWO records always exactly fit per page. I know the total pages by going to preview mode then going to last page and setting $numPages variable and my plan was to pause for the user to insert special card stock then print page 1 (which would be page $i from the loop) and repeat for all pages. One page needs to be fed at a time because the printer will not pick it up from the feeding tray it needs to be done individually. The problems are: If I try to set the print options, it insists on specifying a printer and I do not want to. I want the person to select the printer or use default. I can't s…

Hi! Can anyone assist me on how to accomplish this task. Im developing a Transcript of Record Application where it allows staff to print student records. I have two (2) tables, subjectstaken_hdr 2 and a child table subjectaken_dtl. Displaying the related record from the child table is easy in browse mode. But I find difficulty in accomplishing in Preview Mode. I wanted the printed output similar to an attached format. Ive attached my relationship diagram of my tables, and expect output format of the report. Thanks in advance, Pele

I have a simple script which crashes FM. It is: Allow User Abort [ Off ] Go to Layout [ “Print: Site List” (Site) ] Enter Preview Mode Print [ Records being browsed; All Pages; Orientation: Portrait; Paper size: 8.5" x 11" ] [ Restore: HP LaserJet 2500 ] Enter Browse Mode Go to Layout [ original layout ] It was an older script created in 2013 (not created by me) and the HP LaserJet 2500 is not installed - in fact, my printers are currently offline. I don't believe I've ever had a crash like this before. I am on FMPA 14.0v5 El Capitan 10.11.3 accessing Windows FMS14. Another developer on Windows (8 I think) does not crash. Any suggestions? I would like…

I am trying to take a decision in an area with no experience at all. Thermal printing driven by FM14. After a few searching I have two printers I would recommend for a customer: - Brother TD 4100N -Epson TM T88V (with an Ethernet interface needed) The question is: Is Filemaker able to print in this devices. The tech specifications do not precisely explain any printing language (PCL, Postscript or whatever) and I need to know if any or both devices have been used with Filemaker sending data. The main issue is to print a logo and data of an appointment to give to the persons that ask for attendance. Any experiences with these devices? Or any …

Billing records show reporting TOTAL TRANSFERRED I could not adjust. There are 3 pages report Page 1: To write something on the top, bottom (let's say a total of 30 records) $3520 Page 2: Above $3520; bottom (let's say a total of 60 records) $6920 Page 3: Above $6920; bottom (let's say a total of 78 records) $8310 What should be done this way in order to get the report? Is there a sample file? Waiting for help, thank you. in Report a Product Issue • Share • Reply • Li…

Using Windows 7 and FileMaker pro7 my Hp envy 4500 only printing one page from my database even if it needs more also if I set for multiple copies it only will print one

I have a layout in which invoices can be marked via a radio button selection "Paid" or "Unpaid." I am trying to write a script that will only print the invoice if it has been marked as paid, if unpaid send a message to the user (custom dialog box) that the invoice is not yet paid, but I do not know the correct syntax. I have been trying to use an "if" statement, but that is not working for me. Any help would be appreciated. Thanks!

Been wrestling this for a bit - i have a sub-summary report that has no body part and summarizing and sorting by group and lot numbers in the portal for data entry they appear in natural order (the order entered) There are other fields that are entered or multiple records for one lot number however on the report we need it summarized but we would like the lot numbers to be in the natural order as they were entered in the portal. I am trying to figure out a way to force the lot numbers in the natural order.

Hello again, I am trying to have a sub-summary field repeat only once per page. I have made several different attempts now, and I have ran out of ideas. The field is related to another group of fields. When it spans across pages, it would be nice to relist it. When the field prints every occurrence on the same page, it becomes crowded. I found two threads asking a similar question, but the answers are not very clear to me. It seems like this should be an easy thing to do, but I am out of ideas. 1) http://fmforums.com/topic/55560-repeat-sub-summary-field-new-page 2) http://fmforums.com/topic/85965-sub-summary-report-records-starting-on-new-page …

I've created a database that automatically complies an invoice for time worked. I'm loving how it's working. When trying to generate a report I need the report to include two sets of information (from two different tables), ideally in two separate parts: - TimeCard table - Reimbursements table Both tables are linked to a primary table called Invoicing by the InvoiceID. Creating a report that displays the information individually is easy - I select either the TimeCard or Reimbursements table the Layout Setup window, set to view as list, place the desired fields within the body part setup, and bam. Is there a way to do this without the use of a po…

I recently converted my business database from FMP 11 to FMP 14. I am now having problems with printing a multipart form to my Okidata Microline 320 Turbo printers. I have a OkiLan printer server card in these printers. The form is a preprinted, multipart, tear off form 8.5 in by 8.5 in. The problem that I am having is that the "ticket" is now getting split into two pages and it used to be one on FMP 11. I am sending these print jobs from Windows 7 Pro 64bit. I print approximately 35,000 to 40,000 of these forms a year between about 5-6 printers. I have tried the several drivers from windows (Okidata ML 320 Turbo/D (IBM), Okidata ML 320 Turbo/D (IBM), Okidata ML 420), I …

Hi please can someone help me solve my issue. in my solution i want to allow my user just to print one field which is a container field which has a pdf attached. how would i script this, however i do it i get the entire record how ever i only need the content of this field. please can someone help me out.

Hi everyone I've created a window that opens when the user chooses to print a report. I would like to give them options on how to generate this report (or which layout to go to depending on their selected options). The client is very picky about choosing what information they want available when they print certain reports. Of course, I want to allow them a few options to choose from so they can provide more/less info should they choose. A few of the options I've provided as checkboxes in a global field: - Show line amounts - Show line comments - Include order disclaimer - Show system order notes etc... I know a script using IF statements could di…

I find that reports are one of the most challanging things in Filemaker to understand (at least for me). I have basic projects table and all I want to do is print out the list of projects but grouped by the account they are associated with. I.E. ABC Company Project 1 Project 2 Project 3 Ideally, I'd like a sum of the project value field. I'm confused about the report "parts". I've gone through the wizard like creation process and cannot get them "grouped" by Account name. Now Project Name is in a related table. The only thing in the projects table is the ID_Account. Can someone guide me what fields are supposed to be in what "parts" of th…

Hey everyone. Reaching out to the gurus again I have a situation with printing and I have tried a few things outlined below, but I was hoping someone might offer other suggestions before I go in a completely different direction with this... Ugh Hardware: The computers involved are Windows based PCs and they each have a different brand/model of printer. I only tested it with one other PC so far because of this issue. In case it matters, the related printer is an HP Officejet 6000. It has wireless capabilities, but it is wired to the subject PC. Preface: I have a series of scripts setup to print different layouts based on certain conditions in the in…

I started using 1.1 and am now using 12 with Yosemite. I want to send out 329 A4 receipts, but when I sort them by Zip, only 165 go to be printed. If I code the 165 and send then for printing, only 83 will get there - and so on. I have been exclusively Apple, Filemaker and QuarkXPress since Nov 1985, so I know nothing about computers. Can anyone suggest why it is happening and an understandable solution?

Greetings! I'm experimenting with reports, and I stumbled across this cross-tab report. I am getting close results with this approach, but I am still missing something... Could someone have a look at the screenshots and tell me if this is possible. If so, maybe point me in the right direction. It shows the first quantity, but excludes any others. This may fall within some of the limitations that I've read about. I haven't done much with reports yet. Thanks, GG

Hi everyone. I'm newbie in FileMaker. I'm using FileMaker 14 Advance. Now, I'm having trouble about report. Columns is company name. Row is number water used. I haved used print option 10 across first equal 10 company. But now I want to have date column in the first. How I can do that ? Or have another way to show number water used and date check of 10 company ? Thanks everyone.

AHHHHH!!!!! now thats out of the way hoping for some help here in printing a receipt. I have a small POS i am working on and the issue I have is printing all line items on a receipt from sales_line items table. If I go to the receipt screen in browse mode all items are there (and the receipt looks how it should). However when I print i have only the last item printing above all the totals and all other items have "disappeared" on the printout . I have set to print current record and the layout is in list view. I have used this method for other invoicing and it works as planned but this one drops off all except the last item i know the devil is in the detail but for the …

I recently upgraded to 14.0.3 For some reason the information in the portal is not printing. I only print these award certificates once a year. It printed fine in version 13. If someone could take a look or let me know if there are known issues that would be appreciated. TJ trendsetter certificate fmpa14dot03.zip

Hi, Is it possible to print automatically the sales conditions on each page (e.g. invoices) on the back? (double sided printing)? How? Using Filemaker adv 14. Thank you.

I have a database made up of 3 tables, Company, Event, and Registration. I have created a report showing all of the events each company attend, summarized by Company. What I am trying to figure out is how to create two different reports One Report showing only the Companies that are attending only one event and One Report showing companies that will be attending more than one event. Each report should be able to show the name of the company and the event or events they are attending Can anyone offer me a suggestion or guidance as to how to accomplish this? Thanks Elliot

I'd like some advice on the best way to create reports so that they can be viewed on an iPad but also printed as pdf docs. The reports I need to look at creating would involve a crosstab table, a number of charts and then providing an overall RAG status. The report would need to be viewed on an iPad as that's predominantly how we use FM in my school but also I've want to export it to a pdf doc where so it can be printed. My thoughts at the moment are using SQL with virtual tables to get the summary data for the crosstab alongside some other virtual tables to collate the other information. Then bringing it all together in a layout. Is this the most efficient way of doing…

Hello All, The company I work for uses small "Termal Transfer" printers in order to print the labels for the products they sell. Some of the printers used are: Zebra TLP2844, Zebra ZP200, Zebra ZP455, Okidata LD630T. I'm currently testing with the OKIDATA LD630T which is the one I have available now but the issue is happening with all the other printers as well. Here's the issue, In windows XP everything works fine, when the script to print multiple labels is triggered the print dialog comes up, they put the quantity of prints needed and the system prints those labels. The company had to upgrade the OS to Windows 7, so we installed FMP 6 on those workstations but now …

My problem is that all my layouts has to be printed via PDF or Preview to get it printed correctly. If a send it to a printer (via a generic printer script) it seems to be 2 or 3 lines more, and therefor incorrect for the form. I mostly use A4 Portrait. The problem started when I tried to make Leading Grand Summary after variable Lines (Body). Then I was advised to use Attend to get it correct to PDF. I did so, but it still failed on the printout. Then I removed the Leading Grand Summary, and the Attend to PDF, but the result was negative. The funny thing was that the problem is not just on the layout where I used the Leading Grand Summary, but on the plain layout…

Hope someone can shed some light on my problem. I have a print layout which is for receipts from a till the layout itself is fine except how the heck do I get the footer to slide up (to reduce the massive White Space) I have attached screens of the layout mode and browse mode to show.I have tried all possible options as far as I can make out.

Hi, How do you print the temporary folder if you have to append the pdf where you have multiple pages. Yes I can on the last "Append" select "Automatically Open" but I want to send it to the "Printer" automatically without the user interacting with it. They already interacted with the layout by selecting the "Print" button. So now I need to got to several different layout "Append" the pdf in my "Variable - $Temp Path but I am lost as how to get my temporary folder to the printer without opening it to the desktop. I want it clean, User clicks "Print" ... I save layout as PDF into my $Temp Path .. Append as layouts needed ... then print $Temp Path ... exit script with …

We just installed an HP LaserJet M525c printer and every report that FileMaker 11 prints to it has enlarged logos/fonts (see attached image). We haven't had this issue printing from any other program -- Word, Excel, even printing to a PDF from FM and then printing that PDF with Adobe. I've run different reports from different databases and each time, the report is printed faintly in the background with gigantic wording (the correct field headers and data fields) are blown up over top of it. Has anyone ever had this experience? Any ideas for a solution?

I get this very often now, but with no rhyme or reason why. I print some single bills (tuition bills) out and then for no reason it doesn't print and I get this message: Printing cannot continue because this printer is not connected to a port (which is definitely is, I don't have this issue with other software, only filemaker). Use the control panel to set up a port. I have to shut down filemaker and reopen my software and then it starts working again for a while and then for no reason, again, it gives me the same error message until I close it again. Using FM12. HELP!!!

Having a problem with printing multiple pages when some container fields are set to slide up when fields above are hidden. I have a layout for one to enter expense info along with a copy of a receipt (jpg image). Hard to describe but here's my attempt: I have a 10 page layout with each page consisting of a first row with fields to enter data about, i.e., Reference Number, Date, Location, Reason. Immediately below that row of data is a container field large enough to fill the entire page. That container field is used to display a copy of a receipt (usually from the camera on the iPad using FM Go). If all 10 pages are filled, or even if only the first 5, then the prin…

Hi there I have a found set of data which is heavily filtered to include just what I need in order to prepare a list sub summary report. A particular sub summary part has a GetSummary calculation in it to calculate the value of the figures above, based on a particular break field and date. What I need to be able to do, really for display purposes but this is absolutely necessary, is to add a further figure from outside of my found set to the GetSummary calculation. The figure is displayed via a portal right at the top of the report. It goes like this: Top Figure - A ------------------------------ Sub Summary row B Sub Summary row C Sub Summary row D --------…

Hello I am unsure how to do this or even if it is possible at all. I have a report that reports the Myeloma (Bone marrow cancer) subtype diagnoses corresponding to the year. I want the report to look like and print like this: Year Myeloma MGUS Myeloma-LC Ex. 2010 4 4 2 Total 4 4 2 Now the subtype is in a field called diagnosis and there is a count= count(pk_dx) that counts the diagnosis. I attached a screenshot how the report looks currently. I just want the diagnoses as headers with the years going down vertically. Thank…

Hello, I am in need of creating a printable version of my invoice layout. The layout contains 2 portals, of which the data needs to be printed out from. The first portal is contact information for the client, the second is item/inventory portal, which can range from 1 line to over 100. The printout needs to include all the portal rows from the item list, as well as the contact info. Is there a way to print this data on print report layout, without the report showing the data from all the invoice orders. Currently my print report shows the order number and the item list, however it shows a list of all the items across all order numbers. Is there a way for the report to…

FedEx sent us a Zebra ZP505 thermal label printer to print our FedEx shipping labels. Unfortuantely, neither FedEx or Zebra support the Mac OS. I am running Mac OSX 10.6.8 and there are a couple of Zebra print drivers that came with the OS but neither of them can print to this specific Zebra printer. (According to Zebra, this printer is a custom OEM version of their printer that they produce specifically for FedEx.) I came across a company that sells a FileMaker shipping solution for FedEx: http://www.nrgsoft.com/products/filemaker/fedex/ I have tried their demo and it can print to the FedEx label printer with no problems, so obivously with the proper driver it…

Sorting by a subsummary I'd like to add some info from various records but only works for the info from the first record. I've tried many different ways but none works. I attach a sample file and a picture (fake of course ) of what I'm trying to accomplish. Advices are wellcome . Thank you. Sample.zip

I'm trying to create a report that will use the Trailing Grand Summary the a background color. The issue is that I'm having issue controling what the size is. When the report is generated and the part will use the entire rest of the sheet. Like all things in Filemaker their should be another way to approach this. Any ideas? Thanks

I need to print labels for items (products), and the number of labels (copies) for each product is calculated in a field of the database. Each record calls for a number of items to be labeled with specific instructions for packing (date, location, etc.). For example: Record 1 calls for 3 items type no.1 Record 2 calls for 1 item type no.2 Record 3 calls for 7 items type no. 5, and so on... I have duplicated the number of records in a separate database just for printing, but is so tedious (I have to process one record at a time) and is error sensitive. The databases I work with, generally have between 200 and sometimes up to 2,000 records (or more) per d…

I'm using FMP11 v2 on a Windows 7 x64 laptop. When I print, I get a "Not responding" message and FMP stops working. I must turn FMP off using Task Master. I tried upgrading to v3 or v4 but I can't get the update to work. I've reloaded my printer driver. I'm stumped... any ideas?

I am using FileMaker Pro 13 on Win7. Â While I have been using FMP since ver3, container fields are a new experience for me. Â My coworker and I want to scan the receiving documents we get. Â We get these in batches from the Receiving Clerk. Â One method we are considering would be to scan the whole batch to PDF. Â We would not use FileMaker for this option. Â The other is to scan the individual receiving docs (2-4 pages) to PDF. Â We have this down. Â We can scan a mess of the receivers to our network. Â They auto-name with a date stamp. Â Using Import->Folder I can import the lot. Â There is a receiving number noted on the form. Â As we review each record, we will…

Windows 7 printer settings, when I choose Page Setup manually it works, when I restore from script it works when I choose default printer, but not if the printer in the restore is not the default printer, what to do?

Hi Board! My FM solution has multiple clients running from FMS13. There is a script that the operator runs from a button that takes data from their screen and prints a label. If I want to have networked printers, how do i specify that printer within the script? If 3 operators have 3 separate FM clients and next to each is a networked printer, how do I get the print job from Operator 1 to print out on Printer 1, and Op2 out of P2 etc etc? If I make the script and it is called by the operator, won't it specify the printer that was originally specified in the script, rather than the one that the client is physically next to it? How do i approach solving this pr…

Hello, I am in a bit of a pickle here. I have a small database implemented in FM11 that records information about clients and some notes made by staff. I have to add a print out feature that produces a print out of certain information from the database, however, the document produced must also allow for additional hand written notes to be written - it will later be used in an interview and/or filed in a paper file. The first page of the document is just information from database so is fine. Page 2 however consists primarily of 2 boxes (two different sets of notes) and a small section at the bottom for the signature of a supervisor and filing information. Eith…

Hello:  I'm trying to create an Invoice type report with VERTICAL lines ( see enclosed pic ).  I'm having a difficult time because of the resizing of my fields and it just never seems to work out correctly.   I was wondering if someone has a "best practices" or "trick" to get these vertical lines to work or a way to create an "invoice type" report.  Thank you  Dom  Â

I have 5 tables, all related hierarchically (parent id). What I'd like to accomplish is to make a report of the whole tree. Something like: 1 (T1) 1 (T2) 1 (T3) 1 (T4) 1 (T5) 2 (T5) 3 (T5) 2 (T2) 2 (T1) ... I've tried to make subsummaries of each ID, changing the sort order, using the highest tabla as layout, the lowest, and I came to know... I can't do it. Any advise? I attach a sample file with my trail and error. 5Tables.zip

It did only once. It's been installed, deleted and reinstalled a number of times. Test pages DO come out properly. It does have a port address. Here's the error message I keep getting. Note I'm on a new machine and have installed FM12 advanced. This prints on other machines. Printing cannot continue because this printer is not connected to a port (it is!). Use the control panel to set up a port. I don't get it. Any help??

I have a weird problem in printing from a container file, that I haven't seen any mention of in the forums. I want to present a stored PDF, which is the help file for my solution. I can navigate to a layout with the container presented as optimised for interactove content. The container is large enough to shows a readable interactive PDF with the adobe interface buttons appearing allowing, save, print, zoom in or out and 'show adobe toolbar'. All these functions work as expected EXCEPT print. The print dialogue box opens, but is non-responsive, as if a script step is stuck (this in not scripted - just using the native Adobe function). The only way to get the print dia…

We use FMP to record donations and print acknowledgement letters. The latter is done from a layout into which I've inserted a PDF of our letterhead - actually, a link to that PDF, so I can update the letterhead from time to time by replacing the original PDF. I chose PDF because (a) the letterhead is mostly text, which makes for a small file, ( it's resolution-independant, and © the original letterhead is done in InDesign, which exports to PDF. The layout was done in FMP10. We recently upgraded to FMP13, and now, when I print the layout, the letterhead elements are pixelated. The graphic is also pixelated on-screen, although that isn't so noticeable unless I zoom in. …

I work in a print shop, so there are many, many printers around here. Pretty much everyone with a desk has his or her own printer, not to mention the dozens of other printers around the office and on the shop floor. I have a script that prints multiple forms in rapid succession, generally using other scripts as subroutines. I would like to have FileMaker show the Print dialog when the first form is printed, so the user can select which printer to send the forms to. However, I’d prefer if the user weren’t presented with the same dialog for each of the multiple (potentially many) forms to be printed, since the printer selected in the first dialog will always be the prin…