In the same way your Selection Criteria enable you to tailor the type of information you want, USA Trade Online's Report Features help you organize, manipulate, and format this information.

Once you’ve selected your report type and data dimensions, you can use the following Report Features to manipulate and better organize your data. After clicking the icon from your main Reports Page (see Figure A), USA Trade Online will generate a report based on your specifications. Your Report Features are typically located directly above the first row of data cells (see Figure B).

Figure A: Generating Your USA Trade Online Report

i

Figure B: Report Features on USA Trade Online

For example:

• You can manipulate your data dimensions by using set dimension order or by dragging and dropping them in different row and column locations.
• Any column in a report can be sorted by clicking on one of the small arrows at the top of the column.
• Rank ordering takes sorting one step further by inserting a column with an actual rank (1, 2, 3, etc) into our report.
• Imagine you are trying to find the top ten trading partners of the United States. Instead of going back to your country dimension and manually deselecting the countries coming in at 11 or above, you can use your top/bottom reduction option to restrict the table to just the top ten countries. Likewise you can choose to look at upper- and lower-tier values by percent and sum.
• And much, much more, such as using in-report hyperlinks to get at greater detail and changing the number of report rows and columns in view.

In addition to using your Commodity Selection Criterion, you can use the hyperlinked commodity descriptions to automatically drill down to greater detail in your report. For example, by clicking on Chapter 09 "Coffee, Tea, Mate & Spices" in Figure C, you can tell the system to regenerate the report at the next level of detail. As we see in Figure D this opens up Chapter 09 to the four-digit detail level.

Figure C: Expandable 2-digit HS Code Reports

i

Figure D: Expandable 4-digit HS Code Reports

Changing Report Row and Column Defaults

Drop-down menus are available above your report to help you tailor the default report rows and columns to your computer screen (see Figure E). USA Trade Online allows you to expand your rows and columns as high as 50 per page. For smaller displays, you may want to keep rows and columns in the range of 10 to 15. If you have a large screen with a high resolution, then perhaps 25 columns and rows per page would be more appropriate. Ultimately, this choice will also depend on your research.

Additionally, you can use the Row and Column headers to guide you through the information. To move to another range of rows or columns, click on the arrow boxes . Down arrow pages down, up arrow pages up, left arrow pages left and the right arrow pages right.

• Move to top - Displays the page that starts with the first row in the chart.
• Page up - Moves up one page in the chart.
• Page down - Moves down one page in the chart.
• Move to bottom - Displays the page that ends with the last row in the chart.
• Starting row - Accepts a number and displays a page which has that row at the top.

Figure F: Choose Report Data Rows Dialogue Box

• Move to start - Displays the page that starts with the first column in the chart.
• Page left - Moves one page to the left in the chart.
• Page right - Moves one page to the right in the chart.
• Move to end - Displays the page that ends with the last column in the chart.
• Starting row - Accepts a number and displays a page which has that column on the left.