Multiple tables on one report

[owaring]

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.

[Osman]

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

[owaring]

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

[Lee Smith]

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, 2008 by Guest