Issue
How do I get report data into a Excel spread sheet?
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.