ClarisWorks: Creating Spreadsheet-like Reports

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
Note: ClarisWorks 4.0 includes a list view layout type. The following information explains how to create a columnar report to simulate the list view in earlier versions of ClarisWorks.

You may be familiar with other programs like Microsoft Works and AppleWorks. These programs have their own ways of creating database reports with columns and rows. In AppleWorks these reports are called tables reports. In Microsoft Works they are called spreadsheet reports. ClarisWorks calls them columnar reports. Here is a technique to create them.

1. Select Layout from the Layout menu.
2. Choose Page Setup from the File Menu and select landscape orientation (the rightmost one). This will make the next steps easier.
3. Select New Layout from the Layout menu, choose columnar.
4. Move the fields over to the right in the order you want them to appear (e.g. Firstname, Lastname, Street, City, State, ZIP, etc..)
5. Shrink the fields that do not need as much space and move all the fields so they fit nicely across the screen. You might want to zoom out to 50% to make it easier to see the whole page on the screen.
6. Select Page Setup from the File Menu and select portrait orientation (the leftmost one).
7. You need to move body part up to squeeze the size of the body. This will make each record as slim as possible to fit the maximum number of records possible on a page.

To switch between this view of the record and the old view, you would use the layout menu and switch between the two layouts listed at the end of the menu.

To make even more room for fields going across the page, change the paper size to Legal or an even larger size such as Tabloid in Page Setup. This technique works for viewing purposes only unless your printer actually supports the larger page size you select.
Published Date: Feb 18, 2012