I need to generate a document for any given account that lists a detailed view of their contacts, opportunities, activity etc. My first instinct is to simply use renderAs on a custom visualforce page that contains all the account info I need. However, I'm realizing that I would need to generate such a page for each opportunity connected to the account (and possibly each contact though I might get by with a related list there). Is there a way to generate a page for each item that would appear in a related list so we could see (for example) the description of an opportunity that would be too long for a related list column?
Secondarily, if they do end up being separate pages, how would you recommend turning them into a single document with as little effort on the part of the user as possible?