To...
Do this...
In the Available Columns section, use the arrows to display the columns in the folders that are available, then drag and drop a column title to the body of the Sample Report Data tab or right-click the column name and click Add Column.
You can search on column data, if needed. If you are viewing your data using the Report Wizard, the search field displays over the Available Columns area. After finding the column you want to add, press Enter to add that column to the report.
Important:
If you add a column to a report and that column has required properties,
the system indicates that you need to review the Column Properties 
tab.
The system removes the indicator after you have viewed the Column Properties tab.
Click the header of the column you want to move, drag and drop the column to the right or left depending on the order in which you want the columns to display when viewed or printed.
You can also select the column and then use the Actions menu or right-click, and select Move Right or Move Left to move the column one spot to the right or left.
Select the column you want to remove from the report, use the Actions menu or right-click, and select Remove the <column selected> Column.
Select the column you want to rename, and select Edit Label from the Edit menu. You can also double-click the column name you want to change and enter the new name.
For example, if you add the same data field to the report, but have a different formula applied to each column, you can name each one with specific names, such as changing Cost Code (COGS)-1 to Cost Code (COGS) 2.
Note: The -1 in the example above indicates that this is the second Cost Code (COGS) column on the report, not that it is Branch 1 in your company.
Select the column to which you want to hide, then from the Edit menu, select Hide Column.
Note: To unhide a column, click the Columns tab and re-select the check box for the column you want to add back.
Select the column to which you want to apply a formula, then from the Edit menu, select Insert a Formula.
Select the column by which you want to sort, then from the Actions menu, select Sort/Toggle Sort.
Select the column for which you want a total, then from the Actions menu, select Set/Unset Totals or Set/Unset Subtotals-By. You can also right-click and select Set Total or Set Subtotals-By.
If you apply a total to a percent column, such as GP%, the system totals the numbers, not the values, for that column. To attain a true percentage total, you need to export the report and use Excel to total manually. Totals added to a formula column, even if they contain a percentage, will calculate correctly.
If your total does not display, click Refresh to re-display the current selections.
Note: By default some columns have the Set/Unset Totals feature set, such as theTotal Sales. A summation symbol () displays in the field below the column title. You can remove the calculation, if needed, using the same steps above.
Note: The Totals line at the bottom of each page of the report displays the Grand Total for all the pagesof the report. The value is the same on each page.
Modify how the text looks in a column
Note: Changing text with these options updates both the online display of the report and the printed output.
Select the column that you want to change, then from the Edit > Data Format menu, select the option you want to use:
Style - Change the text to bold or italic. Or align the text to one side of the column, such as right-justified for columns displaying prices.
Note: If you use italics, you may effect the layout or column width you have set.
Date - Indicate how you want dates
to display on the report. For example if you need more room for
other data, you may choose to truncate a date, such as 1/1/09
rather than January 1, 2009.
Note: Eclipse Reports supports variable dating.
Currency - Select how you want large numbers, and negative numbers to display.
Note: When in display mode, the system may not refresh the column data showing your selected option. For example, the system may remove the dollar sign from the currency. The report will still run correctly. This is only a display anomaly.
Click the heading of the column you want to suppress.
From the Actions menu, select Suppress/UnSuppress Detail.
You can also click the Columns tab and deselect the column you want to suppress.
From the Ed it menu, select Edit Column Widths or select a single column and from the Actions menu, select Edit Column Width. You can only select one column or all columns. You cannot select several columns to adjust at once.
Change the widths of columns, as needed.
Note: Columns widths are based on a 12 pt Arial font. If you have a different font selected or are using italics, you may need a larger column width to display all your data.
