Multi section report

[Simon K]

Hi all

I would very much appreciate some pointers on how best to achieve the following:

I would like to be able to produce a "proposal/quote" document.

In my db at the moment there is an "estimate header" table and an "estimate line items" table.

A proposal document has the following sections(structure)

Intro

Restatement of customer objectives (text - this could be more items in the line items table)

Summary of costs (a table with 3-5 rows)eg:

Software----------value (total of software line items)

Hardware----------value

Services----------value

Development-------value

Total-------------value

Not all sections appear every time

After the "summary section" there is a sub section for each of the major headings

so in "software" there would be

preamble (text items again)

and a table of software modules, qtys and prices (ie from line items table)

At the end of the proposal document would be a terms section and some appendicies eg price lists.

Should I look at creating multiple pdf's and appends?

Any pointers really welcome

TIA