create a summary page of portal data

[swf]

I have a table of patients that has a 1:many relationship to many tables.

each patient has many medications, many lab values , many visits etc.

I have a layout for each of these and the data is displayed in a single portal for each. This works great for entering data and viewing data.

I would like to print a summary sheet for each patient with limited data. for example patient name at the top and below it show only active medications, last month of lab values (or last 4 values), and last month of visits.

I can isolate the data by relationships (limit meds to active, limit labs to current date-30 etc) and put 3 or 4 portals on the summary sheet but this is not ideal for printing. should I cut and paste the data into a text box.

In summary I am trying to pull related recent data from a bunch of tables and summarize it on 1 layout. This would need to be easily printed on 1 or 2 pages.