In SchoolFi, Districts can create an endless number of custom reports related to personnel and payroll. Our custom report writer tools that allow users to create personalized reports from existing data, offer features like filtering, sorting, grouping, and charting to extract specific information and present it in a desired format in Microsoft Excel.
Key functions of the SchoolFi custom report writer:
- Data extraction: Connects to various data sources (databases, spreadsheets) to pull raw information.
- Customization: Allows users to select specific fields, define columns, and add calculations or formulas to the report.
- Data manipulation: Provides tools for sorting, filtering, and grouping data based on specific criteria.
- Presentation: Enables users to format the output, add charts, and visualize trends for easier understanding.
- Exporting and Sharing: Facilitates exporting reports to various formats (PDF, Excel, PowerPoint) and sharing them within an organization.
- Scheduling: Allows for the creation of automated reports that run at predefined times.
The "heart" of the custom report writer is the Staff Search tab (highlighted in yellow below) which is nested under the Personnel tab and is your default home tab when logging into SchoolFi. This is where you can set the custom report parameters. The second component is the Search Result View (highlighted in purple below). The Search Result View is where you will select the data to be extracted and reported on in the custom excel report.
Components of Custom Excel Reporting
Utilizing the Staff Search Tab to define the staff members that will be contained in the custom excel report
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Searching for staff members on the Staff Search Tab
Saving the search parameters for future use
Creating a Search Result View
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Creating groups to manage your search result views
Importing search result views from the library
Creating your own search result view
How to "run" a Search Result View or create a custom excel report
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Retrieving or "running" a named search
Creating the custom excel report
How to "run" a Search Result View in the Employee Portal
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Step 1: Creating an Employee Portal Role for the staff who will have access to the custom report
Step 4: Creating the webdesk panel to be viewed in the employee portal
How to merge a Search Result View with the Search Contacts and Address tab
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Creating a Custom Excel Report from the Search Contacts and Address tab
How to merge a Search Result View with Payroll Data
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
How to merge a Search Result View with the Staff Certifications tab
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
How to merge a Search Result View with the Credentials tab
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
How to merge 2 excel reports utilizing the XLookup function
Watch the video for the component: Coming Soon
Information / Knowledgebase Articles Covered:
Merging two excel files utilizing the Xlookup function in excel.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article