Creating Your First Report
Creating Your First Report
Watch the video:
Step-by-step instructions:
To open the Advanced Report Builder, click on Settings, then Provider Build, and then the "Advanced Report Builder" button. (If you do not see the button, see this article for turning it on).
First, click Create New Report in the top right to create a new report:
The Create Report Window
Type in a report name, and select the main (focus) model of the report (see below). Then click Create to create the initial report.
A model in the Advanced Report Builder is a set of data fields from a specific area of SETWorks, for example Authorization data, or Goal data, or Activity Record data.
Note that once you create a report, you can combine data from other models as well. However, the main model is important to select, as it determines what data the system will first pull from the system. All other models combine onto the main model.
This is important for this reason: Envision you are creating a client report that includes authorization information. If you select the main model to be Authorizations, and then you combine it with Clients data, you will only have data on clients that have authorizations. If instead you first select the Clients model, and then later combine authorizations, you will have a report that shows all clients regardless of if they have authorizations. If you want to control this more granularly, see this article.
The Report Builder page
The system will automatically open up the report builder for your new report and automaticaly select 3 columns from that model.
The Report Builder page has 3 columns:
1. The left tabs toggle access to configuring different parts of the report.
2. The middle section shows what columns are selected.
3. The right section shows a preview. The preview updates every time an action is done (a column is added or removed, or a transformation is applied.
Click the dropdown above the selected columns to select additional columns or remove selected columns:
Here we searched for "name" to quickly find the first and last name of the client.
And then expanded the Authorizations model to find the columns related to utilization.
Then once the dropdown is closed, the columns will appear below the dropdown, and the preview will refresh with the new columns.
Rearranging columns
Click and drag on the 6 dots to the right of each column to rearrange columns.
And you are done! Now click Save, and then View Report to test out your first report!
Adjusting who has access to the report
Click the Report Permissions tab, and then check the roles you want to have access to the report.
Related Articles
Creating Your First Task
How Do I Create a Recurring Task? Administrators Tasks are the best way to remind staff about an event or task that occurs regularly. For example, you can use Tasks to remind staff to create a monthly progress review form, or an annual ISP form. In ...Creating a Question
Creating a Question in Form Builder There are many types of questions you can create (Headers, Lists with check boxes and drop down style lists just to name a few of many), but for this section of the Form Builder tutorial we are just going to go ...Creating a Placement Letter
Creating a Placement Letter If you do not have access to the Placement Letter form, please contact SETWorks to have it turned on. Overview There are 3 steps to creating a placement letter: Create a "Job Placement". Create the "Placement Letter Form". ...Build Face Sheet and Activity Records Report - Getting Started
Administrators How do I use the Build Face Sheet and Activity Records Report tool? Setup of Custom Reports The Build Face Sheet and Activity Records Report tool is great for tracking individual's goals, Activity Records and even creating a helpful ...Case Management Report
How do I review Case Management Notes? Administrator The Case Management Report is specific to Missouri TCM organizations and makes reviewing notes easy and efficient. Terminology can be modified within SETWorks to better fit the needs of your ...