Creating reports using microsoft access, Creating reports using microsoft access 107 – Avaya Aura NN44400-710 User Manual
Page 107
NN44400-710 Contact Center Performance Management
12 November 2010
107
Expert reports
9
Click Next.
10
Select the columns and choose how to filter the data. This step is optional.
11
In the Query Wizard-Filter Data box, click Next.
12
Select the columns used to sort the data. This step is optional.
13
In the Query Wizard-Sort Order box, click OK.
14
Select the Return data to Microsoft Excel option.
15
Click Finish.
16
Select 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.
17
Click OK.
18
Select File, Save.
--End--
Variable definitions
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
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
1
Open Microsoft Access.
2
Open an existing database file or create a new blank database.
3
Select File, Get External Data, Import.
Variable
Value
Server application name and IP address (for
example, CCMS_47.10.25.3_DSN)