Browsing a table, Creating a report of your data – Pitney Bowes MapInfo Professional User Manual

Page 140

Advertising
background image

Browsing a Table

There are times when viewing the tabular data in a table is necessary. In MapInfo Professional, this is
called browsing the table.

To browse a table:

1. On the Window menu, click New Browser Window.

2. Choose the table you wish to browse and click OK.

The Browser shows the fields of the data table (column headings) and the records of data (rows).

A Browse menu item gives you further functionality. On the Browse menu, click Pick Fields to display
only the columns of data you want to see. If you wish to show information that is only implicit in the base
table, in the Pick Fields dialog box choose Expression from the Fields in Table list. For more on
expressions see

Deriving Columns

, or

Creating Query Expressions

.

To show or hide the Browser window grid, on the Browse menu, click Options.

To add new records to the Browser:

1. On the Edit menu, click New Row to add a row (or use Ctrl-E).

2. Enter text directly into each field. As you type, press Tab or Shift+Tab to move from field to field.

3. You must remember to save the new information to the base table before exiting the program.

Click the row header, to the left of each row in the Browser window, to select a row. If the Map window
for the table is open, the record is selected as well. To add records to the selection, Shift and drag to
select consecutive records, or CTRL-click non-consecutive records.

Selecting records creates a subset of the table that you can browse, map, or graph, just like the full table.
More on selecting is found later in

Selecting and Querying Data

. You can also create a report of your

tabular data using the Crystal Reports functionality included with MapInfo Professional. The Crystal
Reports User Guide, which is located in the Documentation subfolder of your installation directory to
help you get the most out of this powerful report writing program.

Creating a Report of your Data

MapInfo Professional includes the full report-writing functionality of Crystal Reports. Crystal Reports
enables you to create reports of your tabular data. The Crystal Reports User Guide is included online
so that you can get the most from this program.

To create a report and print it:

1. On the Tools menu, point to Crystal Reports and click New Report. The New Report dialog box

displays. It lists all the open tables.

2. Click the table you want to create a report for, and click Report. The Crystal Reports user interface

displays.

3. In Crystal Reports, Choose Report > Report Expert to display the Create Report Expert dialog

box. The Report Expert walks you through the selection of data, fields, fields to sort by, fields to total,
and styles for your report. Click Preview Sample to see a sample of your report on the screen.

4. On the File menu, click Print to print your report.

Tables with columns containing underscores, temporary column, do not display in the default
Crystal Report. Use the Expert Wizard to access columns containing these elements.

Note:

MapInfo Professional 12.5

140

Creating a Report of your Data

Advertising