kgasman Posted February 16, 2008 Posted February 16, 2008 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
mr_vodka Posted February 17, 2008 Posted February 17, 2008 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.
comment Posted February 17, 2008 Posted February 17, 2008 I think it would be even simpler to stretch a leading sub-summary to just under two pages.
Fenton Posted February 17, 2008 Posted February 17, 2008 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.
kgasman Posted February 17, 2008 Author Posted February 17, 2008 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
Fenton Posted February 17, 2008 Posted February 17, 2008 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.
kgasman Posted February 23, 2008 Author Posted February 23, 2008 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
LaRetta Posted February 24, 2008 Posted February 24, 2008 (edited) 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, 2008 by Guest
kgasman Posted February 24, 2008 Author Posted February 24, 2008 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
Recommended Posts
This topic is 6117 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now