Mulitple columns for grouped report

UCLA Lorna

Registered User.
Local time
Today, 08:09
Joined
Mar 8, 2005
Messages
32
I have a report that prints 1 page per doctor. Each doctor has 1-15 patients that also appear on the page. I want to be able to print the patients names in 2 columns at the below the main text of the letter to keep everything on 1 page. I have done the following:

1. In page setup, under columns, I have chosen 2 columns with 0.1" column spacing and column layout as across then down.
2. sorting and grouping: The letters are sorted by provider last name, then provider first name, then patient last name and then patient first name.
3. I've grouped the provider last name, included a group header, and kept together the 'whole group'.
4. I've grouped the provider first name, included a group header and footer, and kept together the 'whole group'.

I have put the text in the following sections:
1. The main text is in the page header section.
2. The patient last and first names are in the detail section.
3. My signature is in the provider first name footer.

Doing this, I get 1 page per doctor. However, my signature appears in the 1st column for some doctors, and in the 2nd column for others. If I move my signature to the page footer section, there is a large gap between the patient names and the signature. It appears that this gap is determined by the largest space needed for the patients names in the detail section (in other words, the doctor with 15 patients takes up the most room and all the other doctors' letters allocate the same about of space, thus leaving a white space).

Also, the patient names also sometimes start in the 1st column, sometimes in the 2nd.

How do I:
1. Get my signature to always stay in the 1st column?
2. Get the patient names to always start in the 1st column?
3. Have no white space between the patient names in the details section and my signature?

Thank you.
 
Have you looked at can/grow/shrink properties without seeing the layout of the report very hard to help... :)

PS. Thats only part of the problem would really need to see the db to address the other issues..
 
Last edited:

Users who are viewing this thread

Back
Top Bottom