Solved

Printing from Filemaker Pro 8

Posted on 2006-06-12
14
348 Views
Last Modified: 2006-11-18
I have set up an invloicing system in FMP 8 using a portal from a lines item database. The portal idsplays eight lines but has a scroll bar so that more lines can be entered and viewed on screen. The problem enters when I want to print an invoice with more than eight line items. FMP 8 prints only the lines visible on screen when the print order is given. What about an invoice with 20 items to be billed?

BTW, this is a big problem with all FMP fields, not just portals. The software prints only what is visible in the field - or have I missed something? Can anyone out there help me to print ALL info in a field even is not visible on screen?

Thanks,
DonEnnio
0
Comment
Question by:DonEnnio
  • 8
  • 6
14 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 16900694
1st, you should have asked this Q in filemaker topic, it is a fm related pb.
to print portals, you need to make them as big as the max amount of lines to be printed (maybe across several pages), then use the printing/sliding feature to auto-reduce the block at preview/print time.
most of the time, you should not proceed like this, and should use a layout with summary + body in the related records table; you then get a much better report with less work, and won't have any problem with the amount of records as this is all automatic in this case.
let me know if you need more info about this (sorry, but i ignore yr skill and don't know whether I should explain more or not).
0
 

Author Comment

by:DonEnnio
ID: 16902293
Many thanks, lesouef!  I WAS reasonably competent with FMP-6 and earned part of my daily bread constructing FMP databases for a small company. But am having a hell of a time with version seven - which I dislike intensely. For instance, I see no advantage to having multiple tables in one file. FMP-6 worked just fine (and fast enough) with separate files related to each other. I still work that way.
I think you have given me sufficient info to solve my problem, although I am not quite sure what "the related records table" is that you refer to. Is this the invoice table? I will go back and play with both possibilities you mention.
Regards,
DonEnnio
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 16902433
regarding summaries, etc, fm7/8 is the same as fm6.
having several tables in a single file is a major advantage to me, but you can of course go ahead with the old style, which I also do for old projects, porting them is a headache.
and what I call the "the related records table" is the items table, not the invoice.
another way is to concatenate all items in a single file of the invoice at print time; i do this when the page layout is complex (tabs, bold, several typefaces, long descriptions, etc.. all those things which are better done using merge fields in layouts
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16902698
I meant "another way is to concatenate all items in a single field, not file!"
0
 

Author Comment

by:DonEnnio
ID: 16904882
Thanks again,

to answer a question you implied in your first help text, I have to consider my efficiency with FMP as at best "intermdiate." You have obviously had more expereience and your comments have been helpful. I will certainly experiment with the concatenate idea, a possibility that I never before considered.

Regards
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16905038
quite easy in fact.
from the invoice, goto related records.
goto to 1st
loop
define $tmp  = $tmp &  item name & price & whatever & [return]
goto next
end loop
then use $tmp for say invoice::item_list for instance. of course you can improve the stuff with tabs, text styles, conditional returns if the field is empty, etc...
especially useful if you wanna send an email where only one field is used as the body text
0
 

Author Comment

by:DonEnnio
ID: 16905161
Easy... when one knows how ;-).

BTW, this is also my first experience with Experts Exchange, an incredible help source.

Thanks again.
DonEnnio
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 28

Expert Comment

by:lesouef
ID: 16905238
need an example?
0
 

Author Comment

by:DonEnnio
ID: 16905599
Would be helpful ;-).
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16907580
0
 

Author Comment

by:DonEnnio
ID: 16928617
Thanks again, but it will be a while before I try to duplicate your effort ;-) !

In the meantime, perhaps I can impose on your helpfulness once again with a small but mystifying peculiarity in FMP-8 that might interest you. I have always disliked the fact that FMP puts left oriented text directly on the left border where it is a bit difficult to read and simply not very elegant. I would have preferred to indent from the field border a bit without using an empty space that would interfere with sort order, etc. I have never found an elegant workaround for this problem - although perhaps the word "problem" is overdone. Its just a feature that I would like to have available.

On my new FMP-8 update CD, there are the usual collections of templates. I am modifying the template called "Purchase orders" and have noticed that the texts, etc. are no longer jammed against the left field border, but are set in (indented) about one space (or perhaps a half-space) to the right. Great! Filemaker is finally catching up to my ingenious thinking. But not really, when I create a new, left oriented field, the text number, etc is jammed into the left field border just like in the good old days - only now there is an alignment problem. The data in my new field doesn't align with the data in the template field provided by FMP.

Do you have any idea what is causing this - and how do I go about getting this indent in future new databases?

'preciate your help!

DonEnnio
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16929347
I noticed that too; everything was ok untill v7 and for some reason, the 1st character of a block is really a 0 pixel indent, so the 1st character touches the box.
If they wanted 0 to be really a real 0 in v8, they could at least have converted the former layout boxes with 1 pixel indent to keep the same look because, old layouts done in v7 look bad. So far, these is no easy correction, all you can do is to set all boxes with an indent of 1 pixel mini, 2 for popups...
0
 

Author Comment

by:DonEnnio
ID: 16929644
MANY THANKS, HOPEFULLY WE WILL COMMUNICATE AGAIN. I ASSUME THAT YOU ALSO MONITOR THE FILEMAKER QUESTIONS - WHERE I WILL CORRECTLY SUBMIT NEXT TIME.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 16929665
I do monitor filemaker questions, this is even the only thing I do usually!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

SUMMARY Enterprise backup in a heterogeneous network is a subject full of complications and restrictions. Issues such as filename & path structure, attributes and extended metadata always tend to complicate the subject to the extent where either …
In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now