Report Output Types
Every Emplifi Agent report has the first option labeled View As. This allows you to select the method you would like to use for viewing the report results. The following output types may be available for a report (not all reports support all the options):
Web Page/HTML : This is the default option. The report results will appear directly in your browser, in the Results view of the report window. This option will create an HTML file which can be added to an internet or intranet site.
XLSX (Excel Print Layout): The report will be output to a Microsoft Excel spreadsheet. The spreadsheet will include all the titles, headings, page numbers, and other formatting elements of the report. (XLS is also available for backwards compatibility)
XLSX (Excel Data): This option is intended to create a "raw data" format that will allow you to add your own calculations, sorts, and filters without having to step over or delete all the page numbers and headings. For information about this output format, refer to the information below. (XLSX or XLS)
TXT (Tab separated text file): The report will be output to a standard text file. The column values on each row of the report will be separated by tab characters.
CSV: The report will be output to a standard text file. The column values on each row of the report will be separated by comma (,). Data containing a coma will be surrounded by double-quotes (“) and and double-quotes will be replaced with two double-quotes (““).
JSON: The report will be output to a standard text file in JSON format. Each column will be output as an attribute/value pair. Each row will be a single element.
PDF: The report will be output to a Portable Document Format (PDF) file. These files require the Adobe Reader application (formerly called Adobe Acrobat Reader), which is freely available from http://www.adobe.com/.
Word: The report will be output to a Microsoft Word document.
XML: The report will be output in its raw XML format, which is the data format returned by the Emplifi Agent Server.
You should note that due to a technical limitation, any reports that use the Excel, Word, or PDF output types have a limit of 255 characters for any text field, including case texts.
Details about the Excel (Data) output format
This option exports to an Excel spreadsheet without the page breaks, titles, page numbers, sub-totals, and group totals. It shows column cross-totals and column cross-percents, but not total-line percents. It shows a single first row with column labels, but not the hierarchy level labels, since it only shows the basic data. It sets the numeric columns as true Excel numeric types with the correct format, and the percents as Excel numeric formatted percents.
On the Frequency report, if multiple row groupings are specified, all the values appear on the same line as the data (not in a hierarchical format as with the other output formats).