Query results from the OncologyKnowledgeBase (nmOK) are in two general formats: tabular and detailed. Results from queries in the New Drug, Marketed Drug, and Marker modules yield a tabular report. The tabular reports are a summary of records selected by a search. To see more information on a record in a table, click on the link in the first column of the table to see the detailed report. Results from queries in the Company module yield a series of detailed reports. There is no tabular report format for that module.

Both tabular and detailed reports can be copied into Microsoft Word documents or Microsoft Excel spreadsheets. Detailed instructions for exporting reports follow.

Import a tabular or detail report into a Word 2000 document:

From Microsoft Internet Explorer v6.0 or Netscape Navigator 7.0:

1. Select the table by dragging your cursor over the table while pressing down on the left mouse button.

2. Right click on the selected area.

3. Select Copy from the menu that appears.

4. Switch to the window containing the word document into which you would like to paste the table.

5. Paste into document by either:

   1. selecting the Edit->Paste option in the Word menu toolbar

   2. Right click on the document where you would like to paste the table and select Paste from the menu that appears.

6. Save the document as an rtf document to strip the html coding while preserving the table format.

   1. Select File->Save As from the menu at the top of the window.

   2. At the bottom of the Save As dialog box, in the Save as Type dropdown box, select Rich Text Format (*.rtf) from the dropdown list.

   3. Type in a name for the file in the File Name text box

   4. Press the Save button in the lower right corner of the dialog box.

Import a tabular or detail report into an Excel 2000 spreadsheet:

Note: You must save the document in rtf format in Microsoft Word before pasting text into Excel. The HTML selected and pasted from the browser may not format properly when pasted directly into Excel.

From Microsoft Internet Explorer v6.0 or Netscape Navigator v7.01:

1. Follow the above instructions to save the tabular data as a file in rtf format.

2. With the rtf file open in Word, select the table containing your data by placing the cursor anywhere in the table and selecting the menu optio Table->Select->Table.

3. Copy the selected table by right-clicking on the selected table and selecting the Copy option from the menu that appears or by using the Edit->Copy top menu option.

4. Paste the text into the Excel spreadsheet:

1. In a blank Excel spreadsheet, select Edit->Paste Special

2. Select the Unicode Text option in the Paste Special window to paste the text.

5. To format the cells to make the data easier to read:

1. Select the cells containing data.

2. Select the Format->Cells option from the menu at the top of the window.

3. Click on the Alignment tab.

4. Check the Wrap text box.

5. Change the Vertical alignment from Bottom to Top.

6. You can now resize the columns by clicking on and dragging the boundary on the right side of the column heading until the column is the width you want.