Report Data
Overview
Data from multiple points can be displayed in a table. Click on the Report Data menu list option to display the Report Data Request page.
Report Data Request
The Report Data Request page is used to query the database for data from a predefined report group or from selected report points. The data returned from the database query will be organized based on the report group parameters. Click the Display button to retrieve the data specified in the input fields organized under the Select Report, Select Display Time and Interval, Display Options headings. The web browser will remember the report data request parameters and restore them the next time the page is selected. Click Cancel to return the previous page.
Report Data Request (see also the full-size image)
Select Report
| Data Label | Description |
|---|---|
| Report | Select the report group to display from the pick list. Click Report: button to change Report Pick Details and order, see the Report Pick Details section. View button displays the Report Edit page for the selected report, see the Report Edit section. |
Report Pick Details
The check boxes on Report Pick Details page control the items, organization, sort order, and limit the records displayed on the pick list.
Report Pick Details (see also the full-size image)
Select the details to display
- Check the box to the left of a detail to display. Details are displayed in the order shown.
- Check the Order by box for the detail to sort first. Check Reverse for a descending sort.
- Check the Then by box for the detail to sort second. Check Reverse for a descending sort.
- Check the second Then by box for the detail to sort third. Check Reverse for a descending sort.
| Button | Action |
|---|---|
| Move Up | Move the selected detail up one row. |
| Move Down | Move the selected detail down one row. |
| Select All | Select all details. |
| Reset | Reset to default details. |
| OK | Return to previous page with new details selected. |
| Cancel | Return to previous page with no changes. |
Select the limits for the display
| Data Label | Description |
|---|---|
| User | Limit display to reports assigned to the user(s). Click User: button to change the User Pick Details and order. The pick list is a single select list by default. Click the  button to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button.  Reset pick list to single select.  Decrease pick list length.  Increase pick list length. |
| Scope | Limit display to reports with scope: all, public, private. |
| User Group | Limit display to reports assigned to the user group(s). Click User Group: button to change User Group Pick Details and order. The pick list is a single select list by default. Click the button to change to a multiple pick list. Control the pick list length with the buttons that appear below the pick list label button. |
Report Point List
If the selected report group has a point override parameter set to true then the Point List is displayed. The Point List displays the report point, analysis, and display parameters defined for this report data request.
Click on the table column headers to resort the table for this column; first ascending, then descending. Click on the Choose details... button to change the details and display order. Click on a table field to edit the text. Click Add to add an new point; the point list add panel is opened. Click Edit to edit an existing point; the edit panel is opened.
Report Point List (see also the full-size image)
| Button | Action |
|---|---|
| Clear all | Clear selection of all rows in this table. |
| Select all | Select all rows in this table. |
| Add | Opens the edit panel where parameters can be entered for a new record. |
| Edit | Open the edit panel for this record. |
| Select | Select row for applied changes from the edit panel; first select, then clear select. |
| Delete | Mark selected rows for deletion; first select, then clear select. |
| Move up | Move the selected rows up one row. |
| Move down | Move the selected rows down one row. |
| Apply | Assign changed field values to this and all other selected rows in the table. Changed fields are highlighted with a blue-green background while unchanged fields have a white background. |
| Close | Close the edit panel without saving changes; a warning will display if changes will be lost by this action. |
Report Point List Details
The check boxes on Report Point List Details page control the items, organization, sort order, and limit the records displayed on the associated List page.
Report Point List Details (see also the full-size image)
Select the details to display
- Check the box to the left of a detail to display. Details are displayed in the order shown.
- Check the Order by box for the detail to sort first. Check Reverse for a descending sort.
- Check the Then by box for the detail to sort second. Check Reverse for a descending sort.
- Check the second Then by box for the detail to sort third. Check Reverse for a descending sort.
| Button | Action |
|---|---|
| Move Up | Move the selected detail up one row. |
| Move Down | Move the selected detail down one row. |
| Select All | Select all details. |
| Reset | Reset to default details. |
| OK | Return to previous page with new details selected. |
| Cancel | Return to previous page with no changes. |
Report Point Add Panel
Report Point Add Panel (see also the full-size image)
| Data Label | Description |
|---|---|
| Point | Select points to add to the point list from the pick list. Hold down the Ctrl key and click to select multiple points. Hold down the Shift key and click to select points from last selected to current selection. Click button to change Point Pick Details and order, see the Point Pick Details section. Decrease pick list length. Increase pick list length. |
Click the Apply button to add all selected points to the point list. The point list add panel will change to the point list edit panel for the last point added. Then other parameters can be assigned to each point. First click Clear all to de-select all points except the one shown in the edit panel.
Point List Parameters
Report Point Edit Panel (see also the full-size image)
| Data Label | Description |
|---|---|
| Panel | Select the report panel for this point. |
| Point | Select the point from the pick list. Click Point: button to change pick list details and order, see the Point Pick Details section. |
| Label | Enter the report legend for this point. If blank the point pick list label is used. Click button to fill in the default label for editing from the point pick details. |
| Analysis | Select the data analysis for the point readout. See the data analysis appendix for a description of the analysis types. Use default analysis will do the report data request analysis selected. Any other analysis type selected will override the report data request analysis. |
| Data type | Select the type of data displayed: Scaled: Scaled or analysis value Raw: Raw data value Score: Nova score value Rating1 - Rating5: Rating value 1 - 5 Date: Date of data report Time: Time of day of data report DateTime: Date and time of data report |
| Analysis Interval | The Rainfall Intensity data analysis requires an analysis interval. Click button to alternate between interval selection from a pick list or from time interval fields. Analysis (see also the full-size image) |
| Display Interval | Select the time interval for the data analysis. The time interval is used to compute the start time for the data analysis from the end time. Click the button to alternate between interval selection from a pick list or from time interval fields. Use Request Interval and Show Data Reports will use the report data request display interval if selected or 1 day by default. |
| Time Offset | Select the time offset from the report data request end time for the data analysis period, default if 0.0 seconds. A positive time offset starts in the future (After), a negative time offset starts in the past (Before). Click the Time Offset: button to select from a list of intervals. The time offset direction is selected from the After/Before list. Click the button again to use the time offset fields. |
| Multiplier | Multiply the data analysis computed value by this constant. |
| Adder | Add this constant to the data analysis computed value. |
| Data class | Select a class from the report style sheet to define the report data display style. The default style is reportdata. |
| Display score | Select true to change the data class displayed for the data analysis score value. The score value (1-5, 0 for missing) is appended to the data class name. For example if the data class name is reportdata then a score of 1 will use the class reportdata1, a score of 2 will use the class reportdata2, and so on. Missing data will use the class reportdata0. This feature is false by default. /* Report readout background colors for scores */ td.reportdata0 {color:#888888;background- color:#ffffff;} td.reportdata, td.reportdata1 {background-color:#ffffff;} /* white */ td.reportdata2 {background-color:#ffff44;} /* yellow */ td.reportdata3 {background-color:#ffaa44;} /* orange */ td.reportdata4 {background-color:#ff8866;} /* pink */ td.reportdata5 {background-color:#ff4444;} /* red */ |
| Display digits | Set the number of decimal digits to display to the right of the decimal point. Select default to use the number of display digits assigned to the point type. |
Select Display Time and Interval
| Data Label | Description |
|---|---|
| Starting Time | Select the starting time for the report. Click Reset Time to start of day for ending time. Note: the starting time must be before the ending time. |
| Ending Time | Select the ending time for the report. Select Current in the pick list to set the ending time to the current time. The Historic selection is shown when a past ending time is selected. |
| Display Interval | Select the report point time interval for the report. Select Show Data Reports to report data reports at the data report time. Click the button to alternate between interval selection from a pick list or from time interval fields. This display interval is only used if the report point analysis display interval is set to Use Request Interval. |
| Scroll Interval | Select a scroll interval for time paging through report data. Click the Scroll Interval: button to select from a list of intervals. Click the button again to use the time interval fields. When a scroll interval is selected and the report is displayed, then Back, Forward and Now buttons are displayed above the report. Click the Back button to decrement or the Forward button to increment the Ending Time by the Scroll Interval; the report is re-displayed with the new ending time. Click Now to reset the Ending Time to the current time. |
| Refresh Interval | Select the interval to automatically refresh the report data display. Click the Refresh Interval: button to select from a list of intervals. Click the button again to use the time interval fields. This field is only available when the Ending Time is set to the Current time. |
Select Data Analysis
These fields are hidden when the display interval is set to Show Data Reports.
| Data Label | Description |
|---|---|
| Data Analysis | Select the data analysis for the report data display. See the data analysis appendix for a description of the analysis types. Use default analysis will do the default analysis for the point type. |
| Data type | Select the type of data displayed: Scaled: Scaled or analysis value Raw: Raw data value Score: Nova score value Rating1-Rating5: Rating value 1 - 5 Date: Date of data report Time: Time of day of data report DateTime: Date and time of data report |
| Analysis Interval | The Rainfall Intensity data analysis requires an analysis interval. Click the Analysis Interval: button to select from a list of intervals. Click the button again to use the time interval fields. |
| Multiplier | Multiply the data analysis computed value by this constant. |
| Adder | Add this constant to the data analysis computed value. |
Display Options
| Data Label | Description |
|---|---|
| Display Only | Select the display data restrictions: All data: All data, valid or questioned Valid data: Data reports with a valid flag. A valid flag is automatically set by the system when data checking criteria is met. Verified data: Data reports with a verified flag. A verified flag is set by an operator using the data editor to certify that the data is valid. Maintenance data: Data reports with a maintenance flag. A maintenance flag is manually set by an operator to indicate test data not used for public viewing. The maintenance flag is also set when a point of station is out of service or when the data report received has the test flag set. |
| Display Header | Select true to display the report header above the report display panel. The report header is the report name, data analysis, ending time and display interval. Select false to prevent the data table display. |
Report Data Display
After the report data request parameters are entered on the Report Data Request page, click Display to display the report. The report header above the report displays the report label for the report group selected, report data analysis, report ending time, display interval, and the scroll interval and buttons if selected.
Report Data Display (see also the full-size image)
| Data Label | Description |
|---|---|
| Report | Click on the report group label to select a new report group from the report pick list. The new report group is immediately reportted. Click button to change Report Pick Details and order, see the Report Pick Details section. View button displays the Report Edit page for the selected report, see the Report Edit section. |
| Scroll Interval | Click the Back button to decrement or the Forward button to increment the Ending Time by the Scroll Interval; the report is re-displayed with the new ending time. Click Now to reset the Ending Time to the current time. |
Report Data List Details
Click on the table column headers to resort the table for this column; first ascending, then descending. Click on the Choose details... button to change the details and display order.
Report Data List Details (see also the full-size image)
The check boxes on Report Data List Details page control the items, organization, sort order, and affect the data analysis and display of the report data.
Select the details to display
- Check the box to the left of a detail to display. Details are displayed in the order shown.
- Check the Order by box for the detail to sort first. Check Reverse for a descending sort.
- Check the Then by box for the detail to sort second. Check Reverse for a descending sort.
- Check the second Then by box for the detail to sort third. Check Reverse for a descending sort.
| Button | Action |
|---|---|
| Move Up | Move the selected detail up one row. |
| Move Down | Move the selected detail down one row. |
| Select All | Select all details. |
| Reset | Reset to default details. |
| OK | Return to previous page with new details selected. |
| Cancel | Return to previous page with no changes. |
| Detail | Description |
|---|---|
| Display Only | Select the display data restrictions: All data: All data, valid or questioned Valid data: Data reports with a valid flag. A valid flag is automatically set by the system when data checking criteria is met. Verified data: Data reports with a verified flag. A verified flag is set by an operator using the data editor to certify that the data is valid. Maintenance data : Data reports with a maintenance flag. A maintenance flag is manually set by an operator to indicate test data not used for public viewing. The maintenance flag is also set when a point of station is out of service or when the data report received has the test flag set. |
Report Data Print
Click on the Print button at the top or bottom of the Report Data Display to prepare the report for printing. The report data display is redrawn with no links and no Administrator header or menu.
Report Data Print (see also the full-size image)
Use the Print feature in the web browser to print the page. Click the browser Back button to return to the Report Data Display page.
Report Data Export
Click on the Export button at the top or bottom of the Report Data Display to prepare the data display for export. The data display is redrawn with no links, header, footer, or menu in a comma-delimited format.