Show Hide

 

Feedback

  • Contents
 

Known Export Limitations

Some reports might export with a loss of formatting, although the reports do not exhibit a loss of information. The following are examples of known formatting issues that occur when you export an CIC report:

  • Microsoft Word Document Export Type

  • There are occasional differences in precision. For example, numbers shown as "1" in the report preview might be displayed as "1.00" in the Word document.

  • Occasionally, a blank (blank, other than the header) page is at the beginning of the report before the actual data starts.

  • Graphs are usually cut off at the bottom (the footer overlays the graph).

  • With some extra wide reports, the export mis-aligns the columns, that is, it merges two separate lines into one line. We have seen this occur with the Line Activity Summary by Line report.

  • Times might show up as "A" and "P" instead of "AM" and "PM" as they are shown in the preview.

  • XLS Export Type

  • Version 8.0e with default special options

  • Graphics (graphs and logos) never show up.

  • Columns might not align. For example, Line Activity Summary by Line report shows the From: text object in column A while the ?StartLineGroup parameters are listed in column B.

  • Export might not justify correctly. The DNIS Detail report, for example, right-justifies the Call Duration and Hold Time columns, whereas it centers these columns in the RPT, PDF, and DOC export versions.

  • You might see the same differences in precision as listed above in the Microsoft Word Document Export Type. Also, the export inserts thousands separators, such as 1,000.

XLS Export Type
Parameters

Input

Allowed Values

Explanation

Report Name

Identifier Name of Report configured in Interaction Administrator

This is the report definition that will be used to processes the requested report.

Export Type

Acrobat Format (PDF), Character - separated values, Comma - separated values (CSV), Crystal Reports (RPT), Crystal Reports(RPT), Data Interchange Format (DIF), Excel 5.0 (XLS), Excel 5.0 (XLS) Extended, Excel 7.0 (XLS), Excel 7.0 Extended (XLS), Excel 8.0 (XLS), Excel 8.0 Extended (XLS), HTML 3.2, HTML 4.0 (DHTML), Lotus 1 - 2 - 3 (WK1), Lotus 1 - 2 - 3 (WK2), Lotus 1 - 2 - 3 (WKS), ODBC, Paginated Text, Record style (columns of values), Report Definition, Rich Text Format (RTF), Tab - separated text, Tab - separated values, Text, Word for Windows document, XML.

Note: We list file extensions in "()" above to give you an example of file types. Do not enter the information contained in "()". For example, if you want "Acrobat Format" you need to enter exactly that (without the information in the "()". If you enter "Acrobat Format (PDF)", you will receive an error.

Export format to be used for output of report.

Mail To

Textual List of Valid mail addresses for CIC as allowed by other e - mail tools.

List of mail addresses to receive exported report.

Carbon Copy

Textual List of Valid mail addresses for CIC as allowed by other e - mail tools.

List of mail addresses to be copied on exported report.

Subject

Any text

Text to be used as subject of e - mail.

Message

Any text

Text to be used as the body of e - mail.

String Parameter Names

List of Parameter Names

List of strings specifying the names of the string user parameters for the report.

String Parameter Values

List of String values

List of strings specifying the value for each of the parameters named in the String Parameter Values list. They must match 1 for 1 with the String Parameter Names list.

Datetime Parameter Names

List of Parameter Names

List of strings specifying the names of the datetime user parameters for the report.

Datetime Parameter Values

List of Datetime values

List of datetimes specifying the value for each of the parameters named in the Datetime Parameter Names list. They must match one for one with the Datetime Parameter Names list.

Number Parameter Names

List of Parameters Names

List of strings specifying the names of the number user parameters for the report.

Boolean Parameter Values

List of Boolean values

List specifying the values of the Boolean parameters for the report.

Number Parameter Values

List of Number values

List of numbers specifying the value for each of the parameters named in the Number Parameter Names list. They must match one for one with the Number Parameter Name list.

Special Export Options

Depending on export type, any of the following values separated by a semicolon:

LinesPerPage=n

UseReportNumberFormat=0 or 1

UseReportDateFormat=0 or 1

StringDelimiter={character}

FieldDelimiter={character}

DSN={ODBC data source}

UID={logging in user id}

PWD={logging in password}

TABLE={export table}

ExcelColumnHeadings=0 or 1

ExcelConstColWidth=0 to n, where n is the constant column width. Default is 9.

ExcelTabularFormat=0 or 1

ExcelBaseAreaType={PAGEHEADER, PAGEFOOTER, REPORTHEADER, REPORTFOOTER, GROUPHEADER GROUPFOOTER}

ExcelBaseAreaGroupNum=n where n is a group number

ExcelNoWorksheetFunc

When exporting to PDF, HTML, or RTF, users can optionally specify a starting and ending page range.

List of special export parameters used to control export for special export types.

Export File Path Name

Valid file path name

File name with path. The exact intent is dependent on export type. ODBC export will ignore this parameter.

If no path is supplied, the file will be placed in the CIC work directory if one exits, or the temp directory, or the root of the C: drive.

HTML Directory and File Name

Valid file path name

File name with path. The exact intent is dependent on export type. HTML export types will use the file name as the base name for the HTML, and will put any JPG file in the associated directory with the file.

If no path is supplied, the file will be placed in the CIC work directory if one exits, or the temp directory, or the root of the C: drive.

HTML Output Type

Valid HTML export type:

HTML 3.2 and HTML 4.0

Export type

Printer Name

Valid name of printer accessible from server.

Printer name used for output. A UNC path might be required to correct address the printer if it is a network printer.

If no printer name is supplied, the default printer will be used.

Number of copies

Empty to 65000

Tells print engine number of copies to print. Value defaults to one if nothing is supplied.

Starting output page

Empty or 1 to maximum number of pages in document

Specifies the starting page of output. If nothing is supplied, 1 is assumed.

Ending output page

Empty or 1 to maximum number of pages in document.

Specifies the ending page of output. If nothing is supplied then the last page is assumed.

Collate Flag

Empty, or true or false

If empty, the printer will collate by default.

Print File

Valid path file name

Forces output to be printed to this file. This can be used to create PostScript output or to print to file from the Fax Printer to create a file that can be processed for faxing.

If no path is supplied, the file will be placed in the CIC work directory if one exits, or the temp directory, or the root of the C: drive.