For offices coming from Lotus Approach, a crosstab can now look like the one Approach drew:
- The totals of a cell can sit side by side, each in its own narrow column under every
column heading, with a short heading of your own such as Qty or RTotal. New crosstabs start
this way. Crosstabs made before keep their totals one under another until you change it
- A cell can show up to eight totals, up from four
- Show only the last columns: with Year across, a crosstab can show only the latest year,
while its totals still count every year
- On the right, a crosstab can show the Total, the average per column, both, or nothing.
The average has a heading of your own, such as 3 year Average. For a total or a count, a
year with no records counts as 0. Records with nothing filled in across are left out of the
average, and the line above the grid says how many columns it covers
- A total's column, and the subtotal and total rows, can be shaded soft yellow, green,
blue or grey. The shading shows on screen, on paper and in the web page
Also in this release:
- The Reports screen waits until you stop typing before it runs the report again, and only
the newest result is shown. Typing a heading no longer starts a run for every key
- Actual size, on the Reports screen and in Preview, shows the pages at their real size,
so a wide crosstab can be read on screen
- A printed report no longer ends with a blank page
- An average of a number field shows at most two decimal places in a crosstab
- A computer on 1.7.0 or 1.6.0 can keep working with a crosstab made on 1.7.1. A 1.7.0
computer is sent its first four totals, one under another, and when it saves, the host keeps
the rest. The new crosstab settings need the computer that holds the database to run 1.7.1
or later
