I wrote a relational database for a therapist. The main database has personal info like insurance company address contact numbers etc. It is linked to a database that contains all the daily notes written on the patient.

I want to produce a report that has a cover page containing only the patient name and confidential on it. The Second page contains just the pesonal info and starting on the third page would be all the notes related to the patient.

I can't figure out how to achieve this

Any help please

You could make it simple and have 3 different layouts. The script would basically be going to each layout and printing then go to the next one, print, etc.

I think it would be even simpler to stretch a leading sub-summary to just under two pages.

There's also a Title Header, which is automatically on the first page. If you make it tall enough it will be the only thing on that page.

So could I use the title header stretched to one page length for the cover page and a leading subsummary part (to list all the contact information ) stretched to one page length for page two and the body part for all the notes?

The reason I didn't want to print three different layouts is that I wanted to be able to print the document as one pdf to email if needed.

thanks for all the great help

Yes, you could, if you're only doing this for one patient. There is only one Title Header however. So it will work fine for a report on only 1 patient, since you're putting the patient info on the cover page. If you are wanted to report on several patients at a time, with a cover page for each, then you would need to use a (big) Subsummary part, as comment says.

I was able to get the title header to work fine for the first page. I only saw a leading grand summary part that I could use for page two.

The problem is for page 3 and beyond (depending on how many notes I have) I need the header to list the Labels for the field columns. I don't want the labels in the header to show up on page 2 which would contain the contact info.

thanks for any ideas

Keep in mind that, in version 9, you can use new script-step Append to PDF to combine reports. I have not used the feature but it sure sounded nifty! You might give it a try!

Edited February 24, 200817 yr by Guest

your right I am going to look into that.

I wanted to know if you knew why if I made a title header big enough for two pages in the layout mode it won't print the second page when I print.

thanks again