Report Actions › Export Reports to Spreadsheets › Set Up the Column Details

Set Up the Column Details

You can use this page to set up details for all the columns of the spreadsheet that you generate from the report you want to export. For example, you can specify the number of columns, create column headers, and include names for headers, and so on.

Follow these steps:

1. Click Setup Column Details in the Export Dialog.
2. Complete the following information in the Column Details page:

   Current Column

   Indicates which column properties are changed by you.

   Column Name

   Specifies the column name entered. This column name is used as a column header in the exported report.

   Note: This field is enabled only if you choose to create column headers.

   Create Column Headers

   You can choose whether to add a column header to each column. This option creates a column header for each column of your spreadsheet.

   When selected, this option displays the column header and enables column name text box.

Proceed to enter the Column Data Format options to display data in the required format. The options selected in the Column Data Format sections apply to the column indicated by the current column drop-down list. By default, General is selected.

General

Displays the entered data. Data of any type is valid.

Text

Specifies all data in this column must be formatted as text within the spreadsheet.

Date

Specifies the data in this column must be formatted in the date format.

For the date format export to work, you must indicate the format of the date column.

Input Format

Displays the current date in the format you have selected.

Date Format

Select the format that is the closest match to the date format used in your report.

Note: The date format does not have to be an exact match.

Date Locale

Select the locale that is the closest match to the data that is used in your current report.

Note:

The data in this column of your report may not display exactly like the date format that you selected. However, you must select a format that closely matches the date format of your report.

To verify whether the date format entered is correct or not, click Check, under the Check columns. The Check button checks if any dates are not in the correct format or not close enough to the correct format.

Number

Specifies that the column must be treated as numerical data. You can also specify the number of decimal places to be displaced in the spreadsheet.

Note: To verify whether the data entered in this column is correct or not, click Check, under the Check columns, for incorrect date formats.

Skip

Ignores the column. This column is not exported to the spreadsheet.

The column details are set up. Continue to the next step Set Up the Page Range that you want to export.