| Summary | Index |
The Summary page shows you the selections you made on the Select Data page and the Select Fields page to create your query. The data for the table (or tables) are stored internally in each of the available formats. When you click the Show button, the query results are displayed in a separate window in the format you select.
You get to the Summary page when you click the Submit button on the Select Fields page.
The top of the Summary page shows the date when the data was compiled, that is, when it was extracted from the Cancer Registry database. Below that it shows the data selections made on the Select Data page. Below the data selection is a list of Constant Fields and Variable Fields.
The constant fields are the ones that are not displayed in rows and columns in the table (or as "pages" if there are multiple tables). The field value displayed after the field name is the value selected from the corresponding dropdown list on the Select Fields page. The data in the tables is limited to the selected values of the constant fields.
The variable fields are the ones that are displayed in rows and columns in the table (and in "pages" if there are multiple tables). All the values of variable fields are included.
Below the list of constant and variable fields is a set of radio buttons allowing you to select the format of the data from your query. You can select one of the following options:
| HTML: | This format displays the results as one or more tables in a standard web page. |
| CSV: | This format displays the results as a list of comma separated values. A number of programs--including Microsoft Excel--can read files in this format. See Saving the Results below for tips on saving a file in this format. |
| Text: | This format displays the results as a list of tab separated values. A number of programs--including Microsoft Excel--can read files in this format. See Saving the Results below for tips on saving a file in this format. |
After you select the format you want, click the Show button. This opens a new window and displays the results or your query in the selected format.
The best way to save the data from your query to a local file depends on which format you select for the data.
If you select HTML format, then use the browser to save it. From your browser's File menu select Save As. In the dialog that pops up, be sure the type of file is set to Webpage, HTML only (or something similar). There may be a dropdown list labeled Save as type from which you can select this.
If you select CSV or text format, the browser may not save these formats correctly. A better way to save these formats is to copy the data into a text-processing program. For example, Windows users can copy the data into Microsoft Notepad and use that program to save the data. To copy the data, go to the browser's Edit menu and choose Select All, then go to the browser's Edit menu again and choose Copy.