The Advanced Report screen allows users to compile, view, and track specific employee data. The More Search Options feature is used to narrow the criteria for search results that will pull into the report. Users can filter data in the Advanced Report screen, correct and save data from within Advanced Report, and export the report into Excel or a PDF file for printing. The parameters and search criteria set in an Advanced Report can also be saved for future use, and can be easily accessed from the Reports menu.
The Saved Reports screen and My Reports section of the Reports menu work directly in conjunction to Advanced Reports; however, for information specifically on these screens, see Saving the Advanced Report for Future Use (Saved Reports) and Additional Features.
1. In the Human Resources menu, click Advanced Report.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/769/original/41c5903d-7227-48b1-812d-4e43d12d5f05.png)
This navigates to the Advanced Reports screen, where a User search module displays along with More Search Options, as well as a list of available user tabs that can be opened to display the categorized user fields.
2. Enter the employee's name, user ID number, or EIN in the User Search text box.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/773/original/6f7d818b-9916-4c44-9b95-795b2dfcc5d6.png)
3. Click More Search Options to use the options that will define a specific subset of users for the Advanced Report. The More Search Options button allows you to specify who you need to pull into the report.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/775/original/8e991bea-e62c-442c-8303-6aa442b4f8ff.png)
a. As shown in the image, select Name, Username & Profile to define the employees by name, username, and/or profile. You can also select from User Fields.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/777/original/09dcf4fa-2e54-4e01-97b9-b77034427f91.png)
In the search shown, only employees who have the Teacher Profile will be pulled into the report.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/779/original/7db8d955-d63a-41b3-a8a7-124bf4509d8f.png)
b. Click the More Search Options pull-down to select as many search filters as needed. In the example shown, W4 Information > W4 Status has also been selected.
c. To remove a filter, click the black minus sign (delete button).
d. Some filters will allow you to duplicate the data. Click the black plus sign(add on) to duplicate the filter and filter by different data.
4. Click the floppy disk save icon to save the search including all filters so you can easily run the search again.
Click the save icon before clicking Search to save your search criteria. If you click Search first, you will lose your search criteria.
a. In the pop-up window, enter the name of the search, then click OK to save.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/912/original/56dcfc19-1d42-4ba4-b03a-34e398637d8a.png)
b. Once saved, the name of the saved search displays in the top right corner. Click the trash can icon to delete the saved search.
c. If you have applied changes to the search, click the floppy disk save icon to either save a new search or override the existing search parameters.
i. If saving new parameters, update the name of the search, then click Save Copy to save the search as a new search. Click Save & Overwrite to overwrite the original search parameters and overwrite the saved search.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/916/original/83ee36cf-a2a4-413a-b2c3-7d4fe8bf364f.png)
All saved searches display in the More Search Options pull-down in Saved Searches.
5. In the User Search, to use the original search screen, click Use Legacy Search.
If the Default User Preferences and/or My Preferences setting, "Use Legacy Search," is enabled, you have the option to use the legacy search or to use the new search. The Legacy Search is available by default to users on v.11; if the district is on v.11, the New Search will not display.
6. Select the Include Parents check box to include parent profiles in your search.
7. Select the Include Inactive check box to include users who do not have an active enrollment record.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/789/original/ec542405-4907-4b08-9a24-2e4cfb5675df.png)
8. Select the Only Show Most Recent Enrollment check box for the most recent enrollment determined by start date, then end date, and finally by user_enrollment id. When this option is selected:
- A new user with no profiles assigned (enrolled) at all will not display because there is no enrollment to show.
- If a user has multiple profiles at one school, it will return the most recent enrollment at that school (there will be one record row for that user).
- If a user has profiles at multiple schools, it will return the most recent enrollment at each school (there will be one record row for that user at each school).
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/791/original/4dd2a34e-a54a-485a-91ce-4c4ba455e12a.png)
9. Click Hide Filters to hide all the filters including hard-coded filters such as Search All Schools, and added filters such as Test History from the screen. Clicking Hide Filters will not delete the application of the filters when your search is conducted, it only hides them from the screen.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/793/original/ea399022-f42e-40fe-ac37-2b4473885f33.png)
a. Click Show Filters to displays all filters again.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/795/original/fa3528be-77e4-44db-bd58-5ce658f77304.png)
All of the tabs located on the Employee screen are listed in the Available Fields section. Per each category/screen, there is a pull-down, which contains all corresponding fields. Note: The Available Felids listed are based on Profile permissions; therefore, the options may vary.
You can begin typing the name of a field in the Search Fields text box to quickly locate a desired field without having to click through each header.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/797/original/0d8cf178-20be-44a2-8852-1c30a9f9bf6d.png)
10. Upon locating the fields/information you’d like to display in your report, you can drag and drop any of the blue boxes into the Fields to include in Report section. You also have the option to simply click on the green plus sign in order to add the field.
11. Select as many fields as you would like displayed in your report. Once all fields have been selected, you can rearrange the fields to determine how the information will be displayed in the generated report by dragging and dropping. You also have the ability to delete any selections made by clicking on the red X.
![](https://media.screensteps.com/image_assets/assets/008/063/801/original/d94bb144-ef84-4189-b04c-342563b658c1.png)
Only one logging field can be included on the report. If more than one logging field is added, a warning message will display at the top of the screen.
12. Click Run Report when all of the parameters have been set to run the Advanced Report.
1. Once the report has been run, click Modify Report at the top left of the screen to return to the previous screen and modify the parameters of the Advanced Report.
When modifying the report, all criteria set through the More Search Options feature will need to be reentered/reselected.
2. If you’ve selected employee names to display in your report, click on the user to open the Employee screen in a new tab.
3. The results of an Advanced Report can be filtered to display a specific set of data from the results when you click the Filter button to the right of the screen.
a. The field columns in the report will appear as options in the Filter Rules pull-down. To filter the Advanced Reports results, select the field, condition, and criteria by which to filter. In the example shown, the report is being filtered by employees' whose experience length is less or equal to two years.
b. Click Add Rule to add another filter rule.
c. Filter Rules can be deleted by clicking the corresponding Remove button to the left of the Rule.
d. Once the Filter Rules have been set, click the Run Filter button to filter the report results.
e. All Filter Rules can be cleared by clicking the Clear Rules button.
4. Click Only Display Records with Errors to view all data errors found within the results.
Notice that a red box marks errors. These errors can be corrected directly from the Advanced Report screen. All fields underlined in blue or containing a calendar icon can be modified.
![](https://media.screensteps.com/image_assets/assets/006/134/510/original/5a747ae3-91e6-49a8-9b29-2942828b344a.png)
a. When finished click Save to update any corrected data and/or select Show All Records, which takes the place of the Only Show Records with Errors button.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/870/original/5502f879-d329-471a-a750-938450c43f87.png)
5. The Include users without log records in '{$field_name}' check box only displays when a logging field is included on the report. When selected, all users who match the search results will display, regardless of whether or not they have a log record. If this check box is left cleared, only users who have a log record will display in the report. To apply changes once the check box is selected, click Go.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/872/original/6cabe942-62c1-4fc2-bf9a-e57aeda5d2a0.png)
6. You can also use the Search text box to find any kind of information that is housed with the report. Since W4 Status was pulled into this report, you could search for a specific status, such as Married. Type directly into the Search text box then press Enter.
1. To save the report, click Create Report at the bottom of the screen.
Saving the report doesn’t save the results. The data pulled updates in real time every time you run the report. For information on saving the results, see the section on Additional Features.
2. Clicking Create Report navigates to the Saved Reports screen where you can title and save the report. Enter a Report Title, and click OK.
![Saved Reports](https://media.screensteps.com/image_assets/assets/008/063/876/original/77ecc5fa-4019-4cbd-bb9b-cfe1d2af6c41.png)
3. As explained, once the report is saved, it will be accessible from the Reports menu where you can run it at any time. As shown in the image, you can click directly on the report under My Reports or click on Saved Reports to edit the report and run it from this screen. You can also publish the report for other users from the Saved Reports screen.
![Saved Reports](https://media.screensteps.com/image_assets/assets/006/134/525/original/893f2409-44a2-4b52-ab2b-6accb7921754.png)
4. From the Saved Reports screen, you can Run the report or Delete the report.
To publish the report, select the Profiles that should have access from the Allowed Profiles pull-down. This information will save automatically. Note: The option to publish is based on profile permissions.
If needed, click in the Title field to edit the name of the report. You can come back to this screen at any time and edit the title and corresponding information.
5. To view all reports that have been published and made accessible to you by other users, click on the Published Reports tab. Note: Depending on your profile permissions, you may or may not be able to edit Published Reports data.
6. To make changes to a saved report, run the report, then click Modify Report. Make any necessary changes and click Run Report.
To save changes, select the Create Report button.
![](https://media.screensteps.com/image_assets/assets/006/134/534/original/5b3c2eb0-133c-43da-8765-861a6b535f9e.png)
a. To save the report with changes made in place of the original report, select Save & Overwrite.
To keep the original report as is and save the change as a new report, select Save as New Report Instead.
Click Cancel to exit and return to the advanced report.
Use the Filter text box located at the top of each pull-down for a quick search. Begin typing the name or number of the desired field.
![](https://media.screensteps.com/image_assets/assets/006/134/536/original/0ab3a2f8-8306-4cbf-8754-370c62a0859f.png)
To export data to an Excel spreadsheet, click on the floppy disk icon.
![Advanced Report](https://media.screensteps.com/image_assets/assets/008/063/880/original/b4c0115d-4a8d-45f2-a003-369c8e6ea27b.png)
Click the headers to sort data. Click once for ascending results; click twice for descending results. In the image shown, results have been sorted by clicking on Last, First M once; therefore, the listed users start with A.
To make the report full screen, click on the expansion icon (four arrows) next to the Search text box. Once in full screen mode, click the icon again to exit full screen.
To export report data to an Excel spreadsheet, click on the Excel icon in the Export section.
![Saved Reports](https://media.screensteps.com/image_assets/assets/006/134/544/original/f3971dbb-5f4f-4451-96ca-46ca0aaee499.png)
To print data, click on the Printer icon in the Export section.
Click Filters to further breakdown data.
a. To add more than one filter to a column, click on the green plus sign.
b. To delete an added filter, click on the red minus sign.
c. Select the gray arrow for more filtering options.
For more information see Filters.