There are three key things which you can do in your reports, using FSG’s Row Orders feature

• Change the account segment order. There may be times when you want to change the order in which your account segments print.This is achieved by sequence number. For example, your natural account might be defined as the third segment, but you want it to print first then enter a row order with natural account as sequence and attach the row order to the FSG.
•  Display account segment values and their descriptions. There is a Display option on the Row Order window where you can tell FSG to display the value, description, or both for your account segments. So, instead of 01.200.1000, you can have FSG display 01 ABC Company. 200 Headquarters. 1000 Cash. Optionally, you can display the description or account segment value by itself.
  Sort detail rows based on values in a column. You can tell FSG to sort your report’s detail rows based on the values in one of your columns. For example, let’s say you’ve built a sales report which displays current month sales figures for each of your 150 sales offices. If you want to sort this report from highest to lowest sales amount, you simply define a Row Order to tell FSG to sort the sales column in descending order.
• Sort detail rows by account segment values or segment value descriptions. To sort detail rows by an account segment’s values or descriptions, the segment’s display type in the related row definition must be either Expand or Both. Optionally, you can use a content set whose display type is set to Row/Expand or Row/Both.
  

Note: A row order can be saved as part of a report definition, or can be added dynamically at the time you request an FSG
report.

To create a new row order:

1. Navigate to the Row Order window.
2. Enter a Name and Description for the row order.
3. (Optional) Enter Rank by Column information.
4. (Optional) Enter Account Display information.

To sort detail rows by amounts displayed in a column (Rank by Column information):
1. Create a new row order or query an existing one.
2. From the Row Order window, enter the Name or the Order of the column whose values will be used to sort the detail rows. Order corresponds to the sequence of the sorting column relative to other displayed columns in the column set, where the leftmost column has an Order of 1.
For example, assume you’ve defined the following column set:

If you want to sort detail rows based on the amounts in Column 1, enter 1 as your Order. If you want to sort based on the amounts in Column 3, enter 2 as your Order (since Column 2 is not displayed).
3. Select a Ranking method. You can sort amounts in Ascending or Descending order
4. Save your work.

To sort detail rows by account segment values or segment value descriptions (Account Display information):
1. Create a new row order or query an existing one.

2. (Optional) Enter Rank by Column information in the Row Order window.

3. Enter the Sequence number of the segment to use for sorting detail report rows.

4. Enter the Segment name.

5. Choose an Order By method to control sorting of the detail report rows:
• Description — sort by the account segment description.
• Value — sort by account segment value.
Note: If you enter Description or Value as your Order By method, FSG will ignore any information you entered in the
Rank by Column region.
• Ranking — sort by the Rank by Column information.
Note: If you assign the Order By Ranking method to a segment, you must also enter Rank by Column information. If
you don’t, FSG will sort by account segment values. Also, when you use the Order By Ranking method, all segments
following the sorting segment must have a display type of Total or Both. Otherwise, FSG cannot derive the totals needed to
sort the report rows.

6. Enter a segment Display method:
• Description — will display the segment description on your report.
• Value — will display the segment value on your report.
• Value and Description — will display both the segment value and description on your report.

7. Enter a printingWidth for your account segment. If you choose to print a segment’s description, make sure the printing width is large
enough to accommodate the description.
Note: You must also make sure that in your column set definition you have provided enough room at the left of your
report to accommodate the cumulative printing widths of all the segments specified in your row order.