Health Resources and Services Administration

Data Warehouse - Report Tool

User Instructions: Choose a report type from the list below. Each choice provides a different style of output – you’ll see details on the right when you make a selection. After choosing your desired format, select the "Next" or one of the buttons on the Toolbar on the top to continue refining your options. If you are finished customizing your report you may select the "Run Report" button to display your report.
User Instructions: “Filter Results” controls the scope of data included in your report. Use the “Available Filters” drop-down list to select a column from which you want to choose values (State, County, Discipline, etc.). The specific list of columns will vary, depending on which report you are using. After you have selected a column, you will see either a list of the values in that column, or a data entry dialog that prompts you to select a comparison (greater than less than, etc.) and enter a target value for the comparison. In either case, after you have defined the selection, click the "Add" button to put the condition into effect. Once you have added a condition it is shown in the Selected Filters summary at the bottom of the Filter controls. If you change your mind and want to remove a filter condition, click the condition to be removed from the Selected Filters list, and then click "Remove" button to remove it. If you click an indented value (shown with a dash in front of it), only that value is removed. If you click an un-indented item, all of the indented values beneath it are removed.
User Instructions: “Sort By” controls the order in which the report data are presented. Use the “Available Columns” drop-down list to select a column to sort by, and choose either Ascending or Descending from the options beneath the list. Use the "Add" button to include your selection in the Sort Columns list. (TIP: you can reverse the selected sorting order for any column you have already selected by clicking on it in the Sort Columns list, changing the Ascending / Descending selection, and clicking the "Add" button.) To change the order in which sorts take place without having to remove an item and re-add it, click an item and then click the up and down arrows to the right of the Sort Columns list to move it within the list. Click any item in the Sort Columns list and then click the "Remove" button to remove it from the sorting selections. The results of your sorting selections are not applied to the report output until you click the "Run Report" button. You can make several sorting selections and then either apply and view the results, or you can choose to further customize your report first.
User Instructions: The “Columns” feature allows users to arrange or remove columns from the report. To change the order in which the columns will be presented in your report, click the items you wish to move and then click the up and down arrows to the right of the Columns to move the item(s) up or down. To remove items from the “Columns”, click on them and then click the "Remove" button. When you are finished removing, and arranging the columns click the "Run Report" button to update the Table view. (NOTES: (1) This feature does not apply to the formatted report views. (2) For additional information on how to select multiple items from a list, see the "Working With Lists" topic in the Reference section.)
User Instructions: The “Summarize” feature is used to create totals and counts of the data within a report. If the data contain numeric columns (e.g. provider FTE assignments or awarded grant dollars) the numeric columns are totaled. If the data do not contain numeric columns then the data are counted. Use the “Available Columns” drop-down list to determine what grouping and sorting will be applied to the data during summarization. The data are automatically sorted within each defined group, according to the setting of the Ascending and Descending options beneath the drop-down list. The current selections are shown in the Summary Columns list below the Available Columns drop-down. You can change the order of the grouping by clicking an item in the list and then clicking the up and down arrows to the right of the Summary Columns to move it. To remove an item from the Summary Columns list, select it and then click the "Remove Column" button. To view the summarized data, click the "Summarized Data” button.
User Instructions: The “Review” feature determines what is displayed in the output of the report. Choose a report type from the list of available formats to select the one you want to see. After selecting the format you want to see, click the "Run Report" button to see the results of your selection, or click "Next" or the Toolbar on the top to continue refining your options.



* The results for the current data are presented as a table which is divided into subsets referred to as a page. There are page numbers links below the subset table to allow the user to examine the complete result set. Use the horizontal and vertical scroll bars on the results set to view the rows and columns of data within the selected page.

   



expand panel  
 
Current Report Settings                                      
1. Format            

  • Table
         
* The results for the current data are presented as a table which is divided into subsets referred to as a page. There are page numbers links below the subset table to allow the user to examine the complete result set. Use the horizontal and vertical scroll bars on the results set to view the rows and columns of data within the selected page.