Move a column or change the grouping of data

Several reports allow you to move columns. You may want to do this to change the layout as well as to change the grouping of the records.  For example, if you want to group records in the Account Activity Detail report by Transaction Type (eg, Standard Orders, Credit Memos, etc.), you would move the Transaction Type column to become the first column in the report. 

Move a column

To move a column within a report by dragging follow these steps: 

• Click the label of the column you wish to move.
• While holding your mouse button down, drag your cursor to the position in the report where you want to place the column. 
• Release the mouse button. 
• The report will refresh. The column will be repositioned and the records in the report will be resorted based on the new grouping.  

    Note: You can use the Back One Navigation step if you wish to add the removed column back into the displayed report. 
Also, any column you remove from a report will be displayed again the next time the report is generated.

See Also
    Add or remove a column