Printing

LS, I have created a typical print script with pagesetup and then print. When I call it the print is sent to the printer. However, the printer asks for confirmation for use of the media type ( I am printing to A4 ). The layout was defined as A4. Even printing manually ( choosing file > print ) the printer gives me the dialog. Doing the same thing from Word. No problem what so ever. Any info would be appreciated !

I have a Billing and Deposit Portal on a layout. My Portal is sorted and filtered as well with respect to Gradelevl and Term I have made several payments and deposits, for example, I have made payments for :school fees,Tuition,Medical,Boarden, for several Gradelevels and Terms... On my Report, I can only see School fees payment .. But my TotalAmount summary subsummary field gives total values of payment made whereas they ain't visible on the report layout..

About a week ago a weird thing happened, the background on reports on Windows machines only started to print the color BLUE on one of the files. The reports print fine from a MacBook Pro and from FM Go on an iPad. The PDFs from the file are consistent they are created fine from the Mac & iPad platform and blue from the Window's Platform. Objects with a background are not affected, for example the scanned logo shows white. On one of the reports I removed the solid white background and it then printed okay..I tried this on others with mixed results. This happens at my client's office, as well as, from Window 8.1 while running the Parallel 10 on my MacBook …

I have a database that is running on a FM12 server. Today out of the blue all of the layout backgrounds started printing and previewing as dark gray instead of white. The problem is occurring on multiple workstations so it appears to be an issue with the database or the server and not the FMP12 clients. I have one computer that is running FMP13A and it has had mixed results. Sometimes the layouts are white and sometimes they preview as dark gray. Has anyone seen this problem before? Does this behavior sounds like it is a file corruption issue?

I'm trying to make a simple data base for workouts. Some of the tables are: plan, muscle group, exercise... And a join table. From the plan presentation (plan table) and through a portal showing the join table I set the day, muscle group and the exercises. I print the plan as a report from the join table (using day and mg parts to sort) like so: Day 1 Chest - bench press - flyes Biceps - curl - Scott Abs - hanging leg rise What I'd like to accomplish is following day X, to have the list of muscle groups of that day. Something like "Day 1 (chest, biceps and abs). I'll appreciate any help.

I have a button on my screen that, when pushed, will print a label for the current person on my dymo label printer. In that script, I go to the layout for the dymo, print it, go back to my regular layout, reset the printer to my regular dell printer. Problem is, for some reason it never resets to my regular dell printer. Then when I do a regular print, forgetting to change the printer in the print box, I waste a lot of labels! Why can't I switch back? My script goes something like this: Go to Layout - dymo layout print setup to landscape, the label number print currrent record to dymo go to original layout print setup - I tried back to my Dell When I do the ne…

Hi. I've created a report which looks and prints fine from the desktop but when I publish with IWP I can't print the report at all. I know IWP doesn't support printing but there has to be a way. Doesn't there? Thanks for any help. - Mike

Hi all, I have a filemaker customer database and one layout includes a webviewer to display the map from google-maps for a customer's location. While the map is displayed perfectly in browse mode I am having the problem that when I print the record or enter preview mode, the content of the web viewer is blank. I have fiddled with all options in Inspector but I cannot find a way around this and am finding it very challenging! One time only, for no apparent reason it displayed correctly in preview but since then nothing - Is this a known bug? Any help would be very greatly appreciated as I'm getting ready to tear my hair out.... :-/ I am using FM Pro Advance…

Hi All, I have a database which is accessed by two people in the field via IWP and when they create a job card on site I want the system to print that report from the server. I have tried setting an OnCommit trigger to perform the required printing script but can't get it to work as the print function is not supported. My next approach was to use an OnTimer script and set a flag on the job card so a timed find could be performed and then print any records that have the flag set but as I currently use the OnTimer script to trigger a backup one will interfere with the other. Any pointers to achieve an automated print would be appreciated.

I print checks, or I did, using 8.5. Being forced to upgrade my computer also forced me to upgrade to shiny new Filemaker 12. Now I can't print checks. They feed edgewise and my printing scripts selects orientation to rotate the image edgewise. The paper rotates, but the printing image does not. Anyone have any ideas? This is driving me completely nuts! Many thanks in advance! -jim lee

I'm attempting to implement the virutal list technique in a database that generates patient consult letters and such. The transcriptionist transfer text from word documents, after transcribing a dictation, into a text field. This information is then electronically signed by the physician and populated in queue for faxing. After the document is e-signed it is viewable to various user groups at which time the virtual list generates a document in preview mode (for printing, viewing, etc.). However, I can't seem to find a way to "chop" paragraphs towards the bottom of the page. For example, if the first paragraph of a letter is close to 300 characters and paragraph t…

Hi I am a beginner on filemaker pro so have used one of their starter solutions and am trying to adjust it to my needs. I have managed to edit and adjust the record form, but am now having issues with the report not showing up everything I need. I have attached the file as I think that might help understand what I need and what I have done wrong. In the event details I have several characters listed for each scene. However on the report it only shows up one of them for each scene. What I need is for it to show all the characters for each scene. I have the report showing date as a heading then it will list all the information for each scene for that date. I…

Hi I am very new to filemaker pro and have used one of their templates to play with to meet my own needs. I have managed to edit a report layout to look how I want it to, however when i get it to generate a report from those files it does not show all of them, only the second list of them for some reason. I might not be explaining this very well. Basically I have a list of characters for a scene and how many I need for that scene. When it goes to generate a report it only shows up one of the characters listed and the quantity that goes with it, not all of them that are listed. I have attached the screen grabs so someone can have a look and see and hopefully m…

I have an issue with a report where the field border and text baselines will not show up when printing or creating pdf reports. I've checked the inspector, and changed the width and the grayscale of the baselines, all with no luck in getting them to print. Any tips on printing this field?

We have an Evolis Dualis 3 ID Card printer. I'm integrating the creation and printing of ID Cards into our current solution. Everything is going great except for one problem. The printer can print single sided or double sided, but I can't seem to Get File Maker to print a double sided card. It prints single sided just fine. We've been using MS word to print from, and as long as the front and the back are on separate pages it prints double sided as it should. So I set up a layout for double sided cards where the front and back are on separate pages. When I print to anything else or save as PDF they print out on separate pages. But when I print from File Maker with dual…

Running a solution for about 20 users, all on Windows 7 PCs using FMP 11. I need to be able to specify a page setup (some print on 11 x 17 and some must pull from a specific tray to get a color paper) without specifying the printer in the script: I would prefer the printer used be their default printer (note to Mac users: Windows does not have the "Any Printer" selection in the script setup). I can set up everything based on the predominant printer (for all the settings), but the users of the secondary printer have to select their own printer every single time when printing. I am fortunate that the printers are identical (and brand new), in case that helps. Su…

Can anyone tell me if portal sorting is any easier in FM13? I would like to sort a portal by clicking on a header name in the portal. I have seen various techniques which look complicated joseph

How can i print the records that are showing in a portal?

Hello everyone, I am trying to mimic my fields to look kind of like lined paper and I am using text baselines to do just that. On my mac, it looks perfect and I am very pleased but then when I print it does not print the baselines! I have no idea why it won't work. I also tried viewing the form on my iPAD and the baselines do not exist! They show up on my Mac and PC but will not show up on filemaker Go plus they do not print. Doesn't make sense to me, can anyone help? Thank you!

I created a database and it works fine on my desktop. I shared it using network sharing but when i go to preview it when i open it using the remote option on another computer it previews very small. Like if it was meant for an iPhone. Any ideas why? I attached a screenshot showing how it is previewing.Â

I've got a layout for a report with long text fields, so those fields slide up to get rid of the white vertical space between them. At the end of the report there is a portal that displays a bunch of pictures related to the current record. Because of the sliding fields, the portal may start at any position of the page, and very often this means that one of portal pictures will be cut by a page break. Is there a way to control that a portal row doesn't get split between different pages? Thanks!

I've inherited a couple of databases that need some help. I'm hoping I can find a simple solution for page breaks. Running FMP 11 V3 on Server I have a simple, but long report that is four pages long. It is currently set up fairly simply with a header and footer and body in between. The body is tall enough to accommodate the four pages. The problem that came up today (because of system upgrades) is that the print drivers on different machines are giving different page builds. Because of this, the page breaks are different from machine-to-machine (some W-XP, some W7). I tried just adjusting the vertical position of each page's elements, but there is enough variatio…

Hi -- simple one, I hope . . . Let's say I want to create a record Print-Out layout that will include little labels indicating the field (eg. City: Miami), but *only* if there is data in that field. If a field is empty, I don't want a label there wasting space. What's the best way to achieve this? I'm thinking one way is to set up a whole set of "Print_Field" fields, each with an If (NotEmpty . . . ) calculation that returns the "label:data" only if the field has data in it . . . but that seems like an awful lot of extra field creation (50 fields are suddenly 100 fields now)? Is there a simpler, more efficient way to go about this? Thanks! Wickerman

Im trying out FM12 and have a container field used to hold links (via calculation) to image documents. Up to now, the images were saved in jpeg format (1 image per page) for mac/windows access. I am moving to a Mac only environment and prefer to use PDFs, since most of the documents are originally in PDF format - mostly text, so I won't have to convert them to jpegs as I have been doing. Everything works fine except for printing multiple page PDFs. Is it possible to print multiple page pdfs from a container field optimized for interactive content? The layout adds header and footer data to each page, so printing must occur in Filemaker. Other than saving each page …

This layout only prints the header when output to a printer. It prints to a Pdf properly. The is being hosted by FM13 Server (if that makes a difference).

Hello Board, I've read a few posts similar to this and I suppose i know the answer but am looking for a better one! I have 6 Citizen CLP-631 printers, all loaded with different ribbon and different labels. They are dotted about a factory floor and networked. All print fine. I have several scripts that print labels on certain actions, all these scripts work except for the 'Print' bit. Using the 'No Dialog' option, i have set the printer (named 'Label Printer A' through to 'F') and the settings. They don't stick, though. I'll print a Barcode Label on Printer A, then run a Batch Label script and it prints on the correct printer, but thinks the label stock is th…

Hello everyone, Im trying to make a report with 2 summary fields, the problem is that they are from 2 different tables, is this possible somehow? I really appreciate answers.

Is it possible to print from a layout in the current table without that layout being visible to the user. The reason for the question is that while the new themes look splendid I don't want to print using three tons of toner for colour fills and gradients so I want to create a print layout without all the frills but don't particularly want the user to have a different view from the input layout.

Hi All, I have a bit of a tricky situation on my hands and I need some advice. The problem is kind of tricky (at least it seems to be to me) so I'll give you an example of what I am trying to do. I have a list of 20 recipients and 3 document types for each recipient that needs to be printed but the 3 documents have different print properties ie I need 2 copies of one document (1 for signature to be returned and another for the recipients records) and single copies of the remaining 2 documents. In order to allow the change to the print settings I am allowing the user to set the print settings per document type. Once the user hits print and the script …

Hello, Any tips about getting about this global setting of page orientation? Looking at a few plugins but it looks like I am paying for a whole bunch of extra features I don't want. Thanks!

Hi. I am using FM Pro 12.4 Adv and I grabbed up the Starter Solution named "Contacts" as it was quick and seemed to have everything I needed rather than dev a custom solution. Yes, for shame - I took the easy way out! Nevertheless, we got the 150+ records in and then called in the Labels from the layout entitled "Labels" I don't know what form/specification this template was built from - I assumed Avery 5160 which has 3 columns of 10 rows for 30 labels per sheet. I had to go in and tell FM to print left to right, 3 cols. The vertical inter-label spacing is not right. The printing starts perfectly in the first label row then gradually the labels (text data) cr…

Hi Everyone! I'm working on a solution that prints barcode labels from Filemaker using the barcode font. I'll like to purchase a reliable barcode label printer to use as a dedicated printer for this function. There are many printers out there, and I'm wondering whether anyone can recommend a product that is known to work well with Filemaker, whether laser or thermal or other, though I'm told that laser-printed labels tend to last longer. The users will sometimes print out a single barcode, and sometimes print hundreds at one time. For this reason, a printer with that accommodates a roll of labels will be preferable. Thank you!! -J

Hi Forum, I have a question on how best to approach the following problem. - I have a Filemaker FM 11 Server with one FM File shared on it. - I also have my PC on the local network with FM 11 client on it using that file. - My PC has a Labelwriter attached to it, and from my Filemaker File, I can happily print barcodes on my Labelwriter printer directly from my Filemaker file. I have a small layout, which shows the barcode to be printed. Its got just the right format for my labelwriter labels and took me a while to set up. Now, we also have an Apache webserver, that serves content from the filemaker Server / file to the web. It runs Apache and lasso and it work…

in my database i store the photos in container fields and if i want to see all the pics stored i have to make a report on table view and each row is a record . but how to show the pictures in columns? something like a thumbnail grid maybe four , five columns? it this possible in filemaker ? thanks,

Hi, I have a scenario where I have to display the top sales guy's photo on the sales summary page. Top sales guy might change day to day. I want to display the picture of top sales guy always on the summary page. How can I achieve this?

Hello! I´d like to make a report from 2 different tables, any idea on how to do it?, I was just thinking to grab the records that I need from each table and put them together in one general layout just to make and print the report but I don´t know if this could be a good solution. Any advice or info would be very helpful to me. Thanks Sincerely BluiSh

Upon upgrading our users to FileMaker Pro 11 on Windows 7 we have experienced issues with printing. Regardless of what the default print prefrence is the user is prompted to "Manual Feed Heavy Letter" on our HP printers. This does not happen when running FileMaker Pro 11 on an XP machine. Please let me know if you have experienced this and if there are any suggestions on how we can fix it.

I have a contract of employment which runs to 10 pages. I am trying to create a layout report for all of these pages and am having difficulty in inserting the whole COE and page breaks so I can print all of these pages off and also merge some of the data like name, address, date employee started, etc. Can you do a report for 10 pages in Filemaker and merge some fields? I can show you the database and COE if that would help someone who can help me. Thanks for your help in advance and I hope my explanation is OK.

I have a report that is a layout with 3 tabs. Whenever I try and print the report I just get blank pages. 8 blank pages. I have no idea why. Every since my company started using FileMaker we've had issues with printing. I've checked for any weird Sliding things or Hide Objects during printing and I don't see anything. Is there some reason is won't print?

Our system now has about 30 reports and the way I manage them is by haveing a layout with buttons on it that run those reports. I need to simplify it and its really hard to keep it looking neat and tidy. Ideally I could create a table which I could name each report and give a description and when the user clicks on a button it runs the relevant script. Anyone got any ideas?

Hello All, My boss would like me to look at some various reporting practices for FM. This is for an event management company. She was wondering if there is any merit to setting up a separate dedicated "report" table (or even file) that would capture data for financial reports (and other qualitative data) by month or season, etc. I told her that we can always reorganize and summarize information according to date ranges and event types, etc. However, she would like to see if setting up a dedicated table (or even a dedicated file?) that would capture data for reporting deserves a try. Only key summarized figures are necessary for these reports; so I can ima…

Hi there... we have a table of sales orders... I can easily create a report that shows Sales persons and there Profit, number of orders etc etc..... What I am trying to do is append to that report a kind of global framework based on the number of days in the date range for the report... so for example if the report is for 30 days the report should add on a 30x£1000 pound bonus framework. How do I do this? I did think first about just creating a dummy new sales order record for the report at run time that would hold the info but this is VERY messy and would need requite deleting the dummy record afterwards and making sure the serial numbers were reset and eveyt…

Hello all, We recently upgraded to FM12. Upon printing our reports in FM11 the entire thing took 15 seconds. Now the exact same report in FM12 takes 3 minutes and 15 seconds. All help is appreciated..

Hi, I always create different calculations to check my MATH. I noticed I had a problem when I added my "Trailing Grand Summary" fields together to check the total summary column and I discovered that I am OFF by pennies ?? Huh Anyway, I started manually checking and ALL SUMMARY TOTALS are OFF except for ONE???, please see pics ... I also tried managing my decimal within the calculation by Rounding with 2 decimal, within the "Inspector" as well thinking that is was a decimal round issue since the Sub Summary Totals are only off by so little. But, It didn't matter what I did with the decimal, same results. Sum Summary are not adding correctly ?? When ADDIN…

I replaced a customers PC with new Dell XPS 8500, Windows 8, Filemaker Pro, previously had a Dell XPS 8100, Windows 7, Filemaker Pro 11. Â Custom built database with about 1500 records and 15Mb in size print previews fine but omits and leaves out lines here and there on forms printed out from either an Oki ML-420 with Epson FX 80 print driver or Epson Workforce Pro WP-4533. Â I had no issues for 2 years on the Windows 7 box running Win 7 + FMP 11, but now this issue? Â I also installed FMP12 on my Windows 7 & Windows 8 Virtual Machines for testing purposes and used the same database to try to duplicate, and cannot. Â I am however using a HP LaserJet 2100. Â Is i…

I have a pretty complex idea and I'm not sure if it's possible. I'm printing an invoice on letter sized paper in landscape. It prints great, but the address doesn't fit particularly well in the window of an envelope. Here's my idea: I want to print the invoice in landscape like normal, and have the printer print the address on the back of the invoice in a position that would fit in the window if I were printing in portrait. The text would be rotated, which is easy. How do I make a layout where the 2nd page is just the address? I could make a separate layout that prints what I want, but I can't print double sided with 2 different print jobs or they will come out o…

I have an FMP solution for tracking productivity in a manufacturing environment. I gather quantity of parts produced, as well as quantity of parts expected (over time) in a database. I have several reports that summarize the data based on employee, job ID, etc. One of the reports includes the below calculation field to calculate performance as a percentage. Truncate( (GetSummary ( summary of actual parts ; _kf_operation_no )/GetSummary ( summary of expected parts ; _kf_operation_no ))*100;2) I would like to sort the report in descending order, based on this field, but cannot. Any ideas? Thanks, Bill

Hi, monotype Corsiva font style of the text but printing but in a different font writing. how do ? Thanks.

Hello again, I am working on my first report. I have a main table ("Projects") and 3 related tables ("Customers", "Operations" and "Components"). Every record in "Projects" has only a Customer and several Operations and Components. I can work perfectly on Layout mode. The problems come with Preview mode and printing. In Layout mode I can see fields from Projects, Customers, Operations and Components perfectly. If I change to Preview mode I can see only the Projects fields. Inspector option "Hide on print" is unchecked, of course. Thanks in advance and greetings from Spain. Manu

Another FileMaker 12 problem... Google found an unanswered query about the same problem, posted here about a year ago. Has anyone found a solution since then? The problem: Fields in a list are defined with a corner radius of 0 and Line is set to bottom only (or indeed any other partial frame). Everything looks right in Browse and Preview mode - but when printed, the entire field has a pale outline (the intended line is darker). This looks genuinely awful. I have always set a line at the right of fields to create columns in lists. Now it seems the only solution is to draw the lines individually and place them between the fields. Not just a lot of annoying work - i…

Hi all I have reproduced a letterhead which consists of the company's logo and address going down the right hand side of the page (there is content from the top to the bottom). I have done this with a combination of text and images, and container fields (containing a blank image for when the header is not required). I also made the entire layout A4 (including length) in Layout view. The other thing I had to do is expand the main line item description field (in the Body part) to 457px, with sliding up enabled. The problem is that sliding doesn't seem to work if the layout is longer than around 739 pixels, and my layout is around 810. Any ideas? Thanks

I have a database that keeps track of customer service requests. In this database I have three [3] checkbox fields. The 1st identifies the categories of 25 issues with the customer [i.e. Codec, Monitor, Network, Training, etc]. The 2nd identifies the 7 different actions used to resolve the issues [i.e. phone call, ship product, onsite visit, etc.], and the 3rd identifies the specific product family that is experiencing the issues [i.e. presentation system, audio system, video system, etyc]. My question is . . can I set up a FileMaker report that will automatically create provide subtotals based on the combinations that are set in the checkboxes? I don't really want t…

Hi EveryOne, Can FileMaker be used in Dot Matrix Printer ,what is the settings of DotMatrix printer. Thanks

Hi, Having issues getting more than one fields to slide. Have sucessfully got the upper field to behave but no joy with ones below, tried all the slide settings as far as I can see. Any tips?] Cheers, N*

I have a report that is sorted by two sub-summary fields, one being Step #, and one being Time. There is also a sub-summary field below, which is again by Time. Now I want the entire section to not cross a page break, ie: Step # Above Time Above Body Time Below Should all appear on the same page. However, the page break options in the sub-summary sections only allow for each section to be on each page. So it turns to be: Step # Above Time Above Body ---- (page break) Time Below And sometimes the Body for each section split across multiple pages too. While I could have a new page for each Time (Above) and that would generally fix it, I am …

I have a db hosted on Filemaker Server 12 Advanced. When users are using the database and go to print a page, in the print dialog box the print range is specified to be 'page 32 of 32'. So users often get the wrong page printed, or nothing at all, as there are some tables with less than 32 pages at the moment. I tried a script with a print setup when the db is opened, but there is no place to specify the print range in the print setup dialog box, so that did not change anything. How to do I reset the print range in the print dialog box to 'All'?

Thank you for your interest! Â I have a little quandary on my hands. I need to print a single report with ALL of Company's info on it, including all addresses and all phone numbers. Â The issue is, addresses are in one table and phone numbers are in another, both are children of the Company table. Â I only know how to create a report based on a straight tier of grandparent > parent > child > grandchild > etc... (I have attached a demo file on this. Demo also illustrates my issue.) Â BUT I do not know how to create a report where there are TWO children from the same parent. Â How can I create a single report on a parent company with two child da…

I am currently using FileMaker 9 Pro on a Windows XP 32 bit system. When running a script to print a certain layout on one user's profile, I receive the following error message: "The combined size of the Header plus the Footer is longer than can fit on the page. To print, first make the Header or Footer shorter or use longer paper." If I log in as myself on the same computer and run the exact same script, there is no error message and the layout prints fine. As far as I can tell there should be no issue with either header or footer. Is there a user print setting or something along those lines that I can change to fix it?

I have several layouts that are legal contracts. Sometimes, the final page of the contract is just the signature lines. I need some body text on that page. How do I force the layout to break the page in the body so that some text will flow to the signature page?

Hey guys, first time posting on the forum. I've tried searching for a similar question but have yet to succeed. Here is my issue: Recently, FM12 has started to crash whenever trying to print. It only seems to do it from some reports, and it's running on Windows XP. Usually the printing dialogue box appears (attachment), and then freezes. Occasionally, the job will print after I've "end tasked" the program. This happens on 1 page print jobs as well. The printer is a networked printer with a Post Script driver. Any help is much appreciated. Thank you!

I am new to filemaker and I am even more new to subsummary reports so please bare with my two part question. I have two tables: Projects Tasks I have a screen layout to view a project project details but wanted something I could print and I want to do that with a print button. I created a new layout based on "Tasks" that makes use of a sub-summary and sorts by ProjectName. As of now the print button launches the "printable" layout in a new window and tasks are sorted by projects. So far so good. I need the related project to be printed displayed in the new window, not the first record set. Trying to find the answer I found this technique: Freeze W…

Hi, I have a database that was created in FileMaker 11, and everything was working well. We recently upgraded to FileMaker 12, so the database was converted. A user recently had an issue where some text was cut off in a sliding field (field is set to slide up to remove unused blank lines). On screen it looks fine, and in Print Preview it looks fine, but when the page is printed, the last line is cut off. This was tested on multiple printers with different printer drivers. This wasn't an issue when it was a FM 11 file. Not sure how to resolve the problem... Can anyone help??

Situation--in a found set of records: We have integrated bottle labels on our invoice. For each record, page one includes two bottle labels, colors #1 and #2, page two includes bottle labels color #3 and #4. Not every customer orders colors #3 and #4 so we only need to print page one for those customers. Question: Does anyone know how we can stop page two from printing if the color #3 and #4 fields are empty?

I have a report that prints off many line items, and at the end of the report, which may be may pages, I want to add a field - that is global across the line items records, to print on the last page. I tried using the field in the Title Footer field, but that's not what I'm looking for. Any help would be great! :D

I have two scripts that generate the reports I require, however I want to be able to combine them both into a single PDF file. Is this possible in FMP or do I need to use an external application?

Hi, I have 5 tables; Projects, Facilitators, Facilitator Line Items, Products, and Products Line Items. When my customer creates a project in the projects table, they wanted to have the ability to assign Facilitators and Products to each Project. So, on the project table, there are two portals; Facilitators and Products. When the customers creates a project and assigns a Facilitator or Product to the project I capture the information from the Facilitator / Products Table and then create a record in the Facilitator and/or Products Line Items Table, with the associated Project ID. This works great, my customer can assign all the Facilitators and Pro…

Hey, on my layout I have a portal with certain fields and when I print it it looks like it does on filemaker, when I insert a normal field on my layout though, I just see the text I wrote into it, I dont see the actual field when its printed. Any suggestions on how to fix that? it looks like its just plain text on my layout atm.

Creating a client side run-time verison with a Print Setup - will I run into problems? E.g. If I set the page size to A4, It uses my locally installed printer name along with other local printer settings. On a clients computer, if they don't have the same printer, will this script step halt with problems? Do I need to use Get(PrinterName) calculations? Thanks so much in advance for your advice. Have a great weekend!

I would like to have Page X of Y in my report's footer, and but let my user see a Print Dialog. However, if the user switches printers, the page Y is sometimes no longer accurate, as the change in driver causes a reflow of the text and of course Y is already populated.* Apparently, the "current" printer is the last to which the user actually printed. And so, I have a dilemma. Any ideas? Thanks, Barbara *I use the go to preview, go to last page, set the gPageNo technique.

How do I setup to print 5-1/4" x 3-3/4" envelopes in FM 10 and Windows 7? There are no setting in the envelop layout setup that correspond closely to this size.

On a solution at a client site we have added a series of Dymo printers for receipts. Because they had a couple laying around from other uses and a couple new ones were added there is a mixture of these printers on the various client machines. The Print step in the script that generates receipts indicates a Dymo 450 as the pinter. This works great if the client machine happens to have a 450 attached. If there is a 400 attached then the receipt is directed to the default printer, which in most cases is a standard HP printer. Is there a way to use If statements to determine what sort of printer is attached to the client terminal and use different Print command b…

Hi, Today i brought a Thermal Printer. After some hassal, I was able to install the printer. But i faced a problem. My problem is that How can I print Receipt in File Maker Pro 11. This is my scenario. A customer buys multiple products. After adding all the items in portal. I want a simple receipt to be printed. Do i make Report? Or what else is the method of it? Thanks

Hi, I am new on Filemaker Pro. I was getting a error. Here is the scenario i wanted to generate a Daily report using 2 tables. Product, Sale and Sale Detail. As table name shows it stores data regarding products and it purchase and Sell prices. Sale table stores data about sale and sale detail about Products inline. The Report is daily basis it show how much of a single product soled in a day. it unit price and total amount of the sale. I just wanted to add another field of Profit. Which will be calculated as follows Total Sale amount - Total Qty Sold * Product unit Price. This is how it is written in calculation field"s_Sum_Total - Product_Sale Line::Pr…

Sliding of repeating fields seems to have changed in version 12? Background v11: Layout has several clones of a repeating field, each showing a different repetition of the data. i.e.. myRepeatField[1..1], myRepeatField[2..2], myRepeatField[3..3], ... , myRepeatField[16..16] All are set to slide up and reduce enclosure. Result is white space is removed as expected. -- v12.0.1: Recreated layout in new project. Not converted from 11. Layout has several clones of a repeating field, each showing a different repetition of the data. i.e.. myRepeatField[1..1], myRepeatField[2..2], myRepeatField[3..3], ... , myRepeatField[16..16] …

hi, i want to make my list resize depending on its content, at the moment it stays the same, whis means that when i print it it will have a lot of blank space, is it possible, there is a pic attached that is just to give you an idea. Thanks in advance for all of the help, Jafacakes2011. Edit: I am wanting to auto resize the body and it to differ for each record.

Hi. I'm new to the forum (first post), so I hope I'm posting this question in the right place! I have a very simple database (just three fields), and all I want to do is print multiple records from a find set -- about as simple as it gets! I have a script set up to run the find (finding records from a certain date) -- this works fine, and presents the information I expect to see in a List view. I go to File > Print, and make sure the "Records being browsed" option is selected. No problems. But when it prints, it only prints a single record (the record that is physically selected) not the whole find set. I assure you, this has only started …

Hi, I am new to file maker. I wanted to create a report of my monthly sale. For Example For month Jan-1-2012 Product Qty Price Product 1 100 1000 Product 2 200 2000 Total Sale 3000 But i cannot understand it how to make it. I am uploading the File. https://rapidshare.com/files/3524128622/Project_Filemaker%20TuckShop.fp7

Hi folks! Weirdest problem ever! I've created a solution in 12. It prints OK on the Mac, but on the PCs (tried on 3 different), when I do a simple print (from the Print Menu) I get an "Unknown Error". If I create a new solution, it prints OK. I've attached the file (User Admin ; Pass (none)) Thanks! Workspace_Test.fmp12.zip

Hi everyone, because of the need to put several several sets of data on one page, I collected my data in a virtual list and created a print layout from that. The style technique Bruce Robertson described and the explanation here http://fmforums.com/forum/topic/82935-vlist-technique-applying-styles-formatting/ was very helpful to make the data look nice. However, I am stuck with the setup of the horizontal line dividers. If it is clear that all lines are just one line, I could go away with a container. However some lines are two lines high, some just one. What I want to create is this TITLE ---------------------------------- Some text…

WTF - This has to be a wind up for Mac users of FileMaker Pro 12! Pages (iLife 11) does not support mail merge from data sources other than Address Book or a Numbers document - that rules out direct use of FileMaker even with ODBC. Word for Mac 2011(v14.1) mail merge does not recognise the .fmp12 extension and doesn't offer an ODBC option. No doubt I'll get the dumb ass of the week award but even so I'd appreciate some divine enlightenment as to how FileMaker Pro 12 can be used as a direct datasource for mail merging on Mac OSX Lion i.e. no export, additional conversion or other middleware data fudging workflow process. Maybe there's an alternative to Pag…

Greets, all: I'm having a royal brain hernia this morning, partly because whoever bought coffee in our office bought decaf so I'm operating in neural first gear. The issue is I can print one record just fine (Click the Print Button -> This One button) but I'm stuck with how to go about coding the script for all the records in the found set (Click the Print Button -> All button). I couldn't attach the file here for whatever reason (after compacting it, too) so here's a link to grab it: Health Center Forms . As you can see, the report is created through a parent-child relationship with the sub-summary sorting by MED or PRN, then by Start date. I've…

Need help figuring out this problem. I have two reports. Report #1 is a simple report layout and the user uses the default Filemaker PREVIEW and then PRINT and/or PRINT SETUP to choose the printer and options. Report #2 on the other hand is printed from a script. The script contains a Print Setup - performed with a dialog and no page setup options chosen. It then later on does a Print[No dialog] without any print options specified. If I print report #1 and click on the PRINT icon in the FM toolbar and send it to printera and then print report #2 but choose printerb in my scripted Print Setup dialog, the report in error goes to printera. It seems that…

Hi, I have a sub summary report showing open projects for my client. And everything is great; Client, then under the client I show all their open project with a total due. However, I'm trying to add a sub summary under each project listing all expenses associated to each project. And since each expense is in the Expense Line Items Table how can I build the Sub Summary Report to show each expense listed under their respective project ? Hmm ... All the tutorials that have visuals ( I need visuals ) show sub summary reporting when all records and field are in one table. There is a tutorial in Filemaker Forms that is really confusing and I can not seem to…

Maybe it's just that I'm still relatively new to FileMaker Pro, or maybe it's just that I've been working on this project for far too long this weekend, but I'm putting together a script that will switch to the printable version of a layout, print the current record only, then go back. As I'm specifying the print options, however, the dialog targets my current printer as well, so when I save the options, the printer name shows up in the script edit window. Normally I wouldn't mind, except that I'm putting together a runtime solution that'll be up for sale. So my question is, is there a way to get FileMaker to acknowledge the print current record only option while ignor…

Try as I may, I have been unable to format a layout that centers fields on an Avery label sheet. Doesn't seem to matter where I stack the text. The print out will center on some of the labels, be at the top on some of the labels and hang over the edge on others. When I select a new layout I am careful to select from the list of available sizes, in this case Avery 5161. Any ideas how to do this?

I have a solution that is submiting a 70 mb file to the print queue of my printer. I am printing a small amount of records that would all fit on one page. Since the file is so large it is taking a long time to spool. Especially if printed to a printer using parrell. Has anyone else ran into this issue?

I was wondering if there is a way to create a bulleted list in a text field? I am pretty sure I could use a portal with some script to generate the list for printing but I was hoping I could allow the user to do there own paragraph formatting so they could see and style it like they want and then I could just print there text box. Thoughts? Thanks Thom

On the attached sub summary report I have assessment questions sorted by Locations so that the Location appears only once with related questions underneath. I have a field on the far left called Question No and I would like this to increase by one with each sub summary Location. I've tried quite a few things such as creating a sub summary field etc but I can't get it to count like I want it to. I must note that the report is sorted at first by two fields from different tables (and then sorted by Locations) so that the Locations and related Questions appear on the report in the right order. I'll keep trying in the meantime.

Hi all, I have a sub summary report I would like to display 0 values on. It is a simple table that is summarized by product category with an amount for each category. Filemaker only summarizes what is in the found records. I would like it to summarize all 4 product categories even though some product categories have no value in the amount field to summarize. See the example below. This is how it summarizes: Category Amt Product A $1000 Product C $2000 This is how I would like it to summarize: Category Amt Product A $1000 Product B $0 Product C $2000 Product D $0 Any advice would be greatly appreciated. Thanks! Eric

I have a report with two subsummary parts. My problem is I don't know how to keep the subsummary parts together when printing. On some pages the first subsummary part prints at the bottom of the page while the second subsummary part prints on the top of the following page. In WordPerfect, there is a way to select text and click "keep text together." Is there something similar in Filemaker? Thanks, Kevin

Hello, Our old macs are about to pass over, therefore no more Mac 0S 9... We g-have to move all our FMP DB (we are currently running on FMP 4.1) to a newer version. I'm doing tests on FMP 8.5 Advance. As you can see from the two file TEST 1, repeating fields are not sliding up properly. These are just 2 examples but out of the many (using real data) I am not able to find a pattern, it seems ramdom. All repeating fields are properly set to slide up and shrink, there is no object in the layout to stop sliding, in FMP 4.1 everything was working just beautifully Does anyone know why this is happening and how to correct it ? TIA Leo

I have a form which displays and prints fine on my mac, and it displays fine on windows too. The problem is that when I try to print on windows, to the same printer, the fields print giberish. I have checked the drivers, and they are up to date. I have printed with other programs, and it is fine. Any suggestions? Thanks in advance, Fed

Hey, guys. I apologize in advance for this. I know its been covered before, I just can't seem to find a solution that works. Here's a quick rundown. My company books video production jobs. For these jobs, we provide equipment and crew. Some of the equipment is owned, some is rented. One job can have multiple rental items from multiple vendors. Equipment has a category (ie: camera, lighting, audio, etc.) Crew members have a job title assigned (eg: director, cinematographer, Sound) I'm having trouble figuring out how to print all of this information. My table structure goes like this: JOBS > LINES_GEAR (what we own) > GEAR JOBS > LINES_RENT…

Hi everyone! I've been reading lots of post about printing a portal.. but I didn't find a solution which could solve my problem. The problem is the following: I have a table in my DB which is storing bills. Each bill is composed by products. Products are represented in a different table. Both tables are linked by billID. In the layout which is going to be printable, It has a header and a footer where I am placing all the stuff I want to be replicated in every page. Plus, I have a body part which is just composed by the products which are composing the bill. Right now, I am using a portal to place those products. My problem, which I guess is a common problem…

FM 10 Adv. OS 10.4.11. I have this laptop connected to an inkjet printer. I have the printer defaults set to "Fast" speed. If I choose to print through the menu, the correct default print speed appears, but if I print through a script, the printer uses quality speed which is quite a bit slower. Does any one have any insight to this? Thank you.

Hi - I have developed an extensive CRM application since FMP4 and now running on FMP 11. I have a customer inquiry page that presents perfectly in browse mode but in preview or pdf print it loses certain fields. There is no obvious explanation except the fields missing are mainly repeating fields (2 repeats) and total fields - they are not related or portal fields just other fields. If I select the field in layout mode double click and pick another field then it displays perfectly so it is nothing to do with the sliding or don't print option. This image shows the record in browse mode the blue box at the bottom is where the issue occurs Here is the s…

Hi, I'm using Filemaker Pro 11 and OSX 10.6.8. I'm trying to print all records being browsed, but the print dialog box I get doesn't offer me the choice.Here's what I see. Driving me mad! Anyone got the answer? Thanks.Philip

Not sure which category this falls into, but there we go anyway - how do I change the internal database title that appears in File/Print/PDF/Save Records as PDF under "Title" (on a Mac). It seems to be assigned during the creation stage and later it doesn't change unless you do a "Recover..." and it changes to "Untitled". Changing the file's name doesn't affect it.

I have a two page document that I want a forced break to separate page one and two. Is it possible? Page one would end at the leading grand summary and page two would begin with a header and body sections? Can it be done??? Question two: Can I have a footer that only appears on the last page, if I had a document that ran 3-4 pages? As always thanks in advance.

Hello to all I have a report that has a portal in it. In the portal are names of people. When I print the report the names come out in the usual manner. EXAMPLE: John Apple Joe Banana Jerry Carrot Is there a way to get the content of my portal to print thusly: John Apple, Joe Banana, Jerry Carrot Please advise. Thank you John