It's not really an issue with your preview mode. Preview is correctly showing you what you will get when you print from this layout with your current settings.
To fit more columns onto your page you must either change page size and/or orientation in print setup or you must redesign your layout to have narrower columns/smaller fonts in order to fit more of your layout on a page.
It's not uncommon to have two layouts--one for browsing/data entry and one for preview/printing/saving as PDF with each layout customized to suit the needs of each task.
Instead of Table view, you need to use List view. This allows addition of leading parts, grouping, summarizing and also can allow objects in the parts to slide and reduce if all that space isn't needed. When you create a new layout, it will ask whether you want a report ... just follow the 'assistant' and it'll walk you through it. :-)
Laretta: I did try creating my reports using the assisted walk-through with the report layout. However, I would like to also be able to do it from already existing layouts that I put in list or in table view.
I went ahead and went into list view and created subsummaries when sorted by full name. Afterward, I inserted a part for a trailing grand summary. I wanted this trailing summary to calculate my total donation amount, however, this field is grayed out in the selection menu. Why is this? I have a "part" for a trailing grand summary but I cannot select the field that I want it to summarize.
I went ahead and went to manage>database and then found the field titled "donation amount" to check and see if it was in number format, and it is, so I know that is not the problem.
You will need to go into Manage > Database and create a new field - a summary field. Set it to be 'total of your Donation Amount'. Then put this new summary field in your grand summary and it will total for you.
It's greyed out because that's not where you select fields to add them to the layout Part. Click Ok to dismiss your dialogs and use the field tool from the status tool bar at the top of your screen to add the field to you trailing grand summary.
Thanks Phil! Thanks Laretta!
The issue now:
I've created three separate layouts, one that reports total donations per donor, one that reports total donations per year, and one that reports total donations for each fund we have.
The problem is, and I don't understand why, when I change the formatting of one of the formats, the other formats change too!
I am baffled because each of these layouts were created separately. They are not duplicates of one layout that I altered. They were each created one by one, their fields added, etc.
So, for example, when I alter the "total donations per individual" layout so that it reports donations per individual, my "total donations per year" layout shows total donations per individual as well instead of the way I had originally formatted it to reflect total donations per year. Why is this happening and how do I stop it?
I believe that you used this question to start a new thread. See my response there.