Expert reports

9Click Next.

10Select the columns and choose how to filter the data. This step is optional.

11In the Query Wizard-Filter Data box, click Next.

12Select the columns used to sort the data. This step is optional.

13In the Query Wizard-Sort Order box, click OK.

14Select the Return data to Microsoft Excel option.

15Click Finish.

16Select where to import the data returned from the query. The data can be imported into a new worksheet or imported into the current worksheet. When importing data into the current worksheet you can select the starting row and column for the data.

17Click OK.

18Select File, Save.

 

 

--End--

Variable definitions

 

 

 

 

 

Variable

Value

 

 

 

 

<ODBC entry>

Server application name and IP address (for

 

 

example, CCMS_47.10.25.3_DSN)

 

 

 

Creating reports using Microsoft Access

If the application supports importing data using ODBC, use the application, such as Microsoft Excel, for report creation.

Prerequisites

A connection to the server must be defined. See Defining a connection to the server (page 98).

Attention: The steps in this procedure refer to Microsoft Access 2002 only. The steps required can vary from different versions of this application. Refer to the application documentation for details about how to import data.

Procedure steps

Step Action

1Open Microsoft Access.

2Open an existing database file or create a new blank database.

3Select File, Get External Data, Import.

NN44400-710 Contact Center Performance Management

12 November 2010 107

Page 107
Image 107
Avaya NN44400-710 manual Creating reports using Microsoft Access, Query Wizard-Filter Data box, click Next