July 23, 200817 yr I'm hoping you can help me with a report I'm trying to create, it will form my invoice and pull data from several related tables. It should be made up of a header with data mainly from one table and a few related fields from contacts. The area I have problems with is listing fields from my one table as well lists from two other tables Below is a brief template. ___________________ Header. static. ___________________ Equipment list many lines auto expand height ___________________ Labour list many lines auto expand height ___________________ Expenses list many lines auto expand height ___________________ Footer static ___________________ What steps do I need to take to achive this? I have all the data related correctly, and have a layout that presents it all in different tabs with no problems.
July 23, 200817 yr Hi Owaring, You can use portal to show records from related tables. Place a portal with 100 (if it is enough) rows. Select sliding printing option for portal and objects under the portals. The empty portal rows disappear and remaning content slides up in preview mode. I think this solves your problem. F. Osman Cabi
July 25, 200817 yr Author thanks for that, that works for now, but with the following 2 drawbacks 1) how can i control the page breaks? the portal lines can be split across 2 ages at present. 2)am i correct in thinking I'm limited to how many lines my portals can have? if so this could be a problem. thanks
July 25, 200817 yr This is a problem that has been discussed many times in the past. You have ran into a couple of reasons why you should be printing your reports from the Portals, you will find more if you search the forum for Printing Portal and Reports. Just do an [color:red] Advance Search of the [color:red]Forum for [color:blue]+Printing +Portal +Report (include the pluses as shown) and you will find a lot of help on this problem. HTH Lee Edited July 25, 200817 yr by Guest
Create an account or sign in to comment