Printing Reports (Form View One to Many)
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?