AnsweredAssumed Answered

Printing Reports (Form View One to Many)

Question asked by revmk on Sep 7, 2010
Latest reply on Sep 7, 2010 by philmodjunk


Printing Reports (Form View One to Many)


Hi all,

I'm in the process of trying to write a report for the following setup

Key: [table (field names)]

[Tbl_client (client_ref)] Relationship to [Tbl_quotes (client_ref, quote_ref)] Relationship to [Tbl_items (quote_ref)].

OK, so now I want to print a quote showing all the items related to said quote.  I started to build this in the form view using a portal.  However it appears that portals are not really great for printing as a) I can't get the sliding to work and b) I suppose the report could go on and on.

So I tried creating a report based upon [Tbl_items] with a header and body.  This produces a report with many pages (one for each item) within the form view.

Is it possible to create what I want to in a form view and if so how?

Thanks all.