Reports & Portals

[Genx]

Just a small problem, im trying to make an invoice (report). Two tables, related by a 'client ID'. One table contains the invoice items and the other the clients. When generating an invoice for a client im a bit confused as to how to only show the info for that client in the report, ive tried using a sub summary part by client ID, and then using related values from invoice, but although it shows the correct information it only shows one record, anybody want to point me in the right direction please?

Cheers for any help, genx

[Søren Dyhr]

Go to the related record and make it there instead via a GTRR(SO) ...with 7 can you tunnel values from the primary side of the relationship. It's only a matter of layout the right way.

--sd

[Genx]

And perform a find of the client first in the related table?

[Søren Dyhr]

Yes, the GTRR will work from the selected record, which better be the client to whom the invoice is made for.

--sd

[Genx]

Righto, cheers for the help :