#### Exchange

Exchange is Microsoft's successor to MS Mail. Exchange, however, includes not only e-mail, but also management of group scheduling, electronic forms, groupware, and Internet connectivity. An Exchange folder can contain standard notes (mail), files, and instances of Exchange forms. All of this data is stored in the Exchange Information Store.

Seagate Crystal Reports can report on data contained in the Exchange Information Store. Exchange data sources available for reporting include:

- Message Tracking Logs
- Address Lists
  - Personal Address Books
  - Global Address Lists
  - Distribution Lists
- Exchange Folder Contents
  - mail messages
  - Exchange Form applications
  - properties of OLE documents
- Exchange Administrator
  - properties of Exchange mailboxes on the Exchange Server
  - properties of public folders on the Exchange Server
  - replica list of public folders
  - ACL (Access Control List) of public folders.

You can use each Exchange data source like a database table and you can link each Exchange data source to other data sources. For example, you can join the Message Tracking Log to an Address List by using an e-mail address as the link field.

The data translation file used to access the Exchange data source depends on the data source that is being accessed. The following table lists each of the Exchange data translation files and describes their purpose:

File name | Data source
--- | ---
P2strack.dll | Message Tracking Logs
P2smapi.dll | Exchange Folder Contents and Address Lists
P2sexsr.dll | Properties of Exchange Mailboxes and Public Folders
P2srepl.dll | Replica Lists of Public Folders
P2sacl.dll | Access Control Lists (ACL) of Public Folders
P2soutlk.dll | Microsoft Outlook

Exchange translation files work directly with the Microsoft Messaging API (MAPI). MAPI acts as a database engine for Exchange data.

##### How the Report Designer treats Exchange data

Seagate Crystal Reports treats Exchange Administrator data (Public Folder Admin, Public Folder ACL, Public Folder Replica, and Mailbox Admin server types) as a physical database server. To access this data, you must log on using a SQL/ODBC server and select the appropriate tables from the Choose SQL Table dialog box.

When you log on to any of the Exchange Administrator servers, you must select a profile (or profiles). Each profile represents an Exchange Server.

Note: Refer to your Microsoft Exchange documentation for more information about how to set up and create Exchange profiles.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com