Method of Getting Report data into a Excel Spread Sheet.

Issue

How do I get report data into a Excel spread sheet?

Product Line

Andover Continuum

Environment

Continuum 1.6  thru  1.94

Microsoft Office 2003,  2007

Cause

Exporting data to Excel allows it to be used and shared in a common format.

Resolution

Create a Report:

Source Tab:

Data Source = Extended Log

Chart Type =  Text

Chart Subtype=  AccTextXML

Output Tab:

Heading = %r

SubHeading =  Report created at %t

Display the full path in the report  = Selected

OutPut to File  = Selected     Select the path. =  Example  c:\Report.txt

Filter:

Select Time interval

Add Data points.

Save:  then Run Report:  The file should have been created in the selected directory.

Goto the selected directory  and right click on the file and Open with Microsoft Office Excel.

You will be prompted with some choices select "As an XML List"

Save to desired location as a xls file.