NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 11

changes.mady.by.user Frost, Ruth (NIH/NCI) [C]

Saved on

compared with

New Version Current

changes.mady.by.user Frost, Ruth (NIH/NCI) [C]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Moved conditionally-hidden note up.

...

To do this...

Do this...

Configure the report settings

Click Report Settings. The Report Settings dialog box appears. For instructions, refer to Generating the CTRP Data Table 4 Report.

Show If
groupGP-CFW_ADMINS, GP-CFW_CTRP_DEV, GP-CFW_NCI_CTRO_DEV
Info
iconfalse
titleNote Visible to Internal Users Only

For instructions on configuring internal reports, refer to NCI CTRP Internal Reports Reference Guides.

Choose which columns to display

In the row of buttons above the report, click Show or Hide Columns. A list of available columns appears. Check or clear the boxes to indicate which columns you want to show or hide. You can also click Show All or Hide All, or type the name of a header to filter the list.

Export all records to a file
  1. In the row of buttons above the report, click Export Table. The Export Table dialog box appears.
  2. You can specify a different file name.
  3. Select the output type (XLSX, CSV, or PDF).

    Show If
    groupGP-CFW_ADMINS, GP-CFW_CTRP_DEV, GP-CFW_NCI_CTRO_DEV
    Info
    iconfalse
    titleNote Visible to Internal Users Only

    The XLSX option is available only for the CTRP Data Table 4 report.

  4. Click Export Table. Depending on your selection, the system generates a Microsoft Excel (XLSX) file, comma-separated values (CSV) file or a Portable Document Format (PDF) file.
  5. Download the file as indicated by your browser's prompts.
Info
iconfalse

If your report contains values with leading zeros (such as in the Protocol ID column), be careful how you open the CSV file:

  • If you open it in a text editor, that type of application retains all leading zeros.
  • If you open it with Microsoft Excel, that application discards leading zeros in numeric values.
  • If you use the Text Import Feature in Microsoft Excel, you can specify the data format for each column (such as Text for the Protocol ID column).

For details, refer to the online help provided with the application you want to use.

The XLSX option is available only for the CTRP Data Table 4 report.

HTML Comment
hiddentrue

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/keeping-leading-zeros-in-csv-file-format/236e23cb-9a00-4c30-bd2b-267d7a3140ac?auth=1

Show If
groupGP-CFW_ADMINS, GP-CFW_CTRP_DEV, GP-CFW_NCI_CTRO_DEV
Info
iconfalse
titleNote Visible to Internal Users Only

Sort your results by column

Click a column heading.

Move hidden columns into viewMove the horizontal scroll bar to the right or left.
Choose how many rows you want to display per pageIn the lower left corner, from the Show selector, select the number of rows.
Move to the previous page of resultsIn the lower right corner, click Previous.

Move to the next page of results

In the lower right corner, click Next.

Move to a specific page of results

In the lower right corner, specify a page number.