--- title: "Run, filter, and export reports" slug: "run-report" updated: 2026-05-18T22:51:26Z published: 2026-05-18T22:51:26Z canonical: "help.servicetitan.com/run-report" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt > Use this file to discover all available pages before exploring further. # Run, filter, and export reports ## Overview Reports help automate business processes and give you insights into how well your business is running. For example, you can run timesheet reports that can help streamline payroll processing. Or, you can run marketing reports to measure the effectiveness of your advertising efforts. Filters and other tools let you customize reports for your business needs. [Run, Filter, and Export Reports Video](https://fast.wistia.net/embed/iframe/idc3krgqb0?web_component=true&seo=true&videoFoam=false) ## --- ### #### Who uses this feature - Office employees ## Things to know - Access to reports is managed through [reporting permissions](/v1/docs/set-reporting-permissions). Contact your account administrator for assistance. - By default, reports on the *All Reports* screen display on cards in a grid. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-6kivossz.png) - To view reports in a list, click **List view** at the top of the *All Reports* screen. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-3l0uxzg1.png) - Each card includes the report name, details, and the template the report is based on. Depending on your reporting permissions and the report’s [sharing settings](/v1/docs/manage-report-sharing-settings), you can perform the following actions: - Click the report name to open the report. - Click **Calendar** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-event.png) to [schedule the report](/v1/docs/schedule-reports). - Click **More** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-more-vert.png) to [edit or duplicate the report](/v1/docs/edit-custom-reports). ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-3emyg20i.png) ## Run a report 1. Go to the navigation bar and click **Reports**. The *All Reports* screen opens displaying reports on cards in a grid. 2. Click the name of the report you want to run. > [!TIP] > **Tip:** *Enter the first few letters of the report title in the search bar to filter the list of reports. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-hl2999bo.png)* 3. Use the dropdowns and date fields to create filters for your report. For example, you may want to filter a report by business unit or by individual technician. Each report has its own set of filters. > [!TIP] > **Tip:** If you want the filters to be automatically selected each time you run the report, once you’ve set the filters, click **Save Changes**. This saves your selected filters for future reports. > > ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-c5z6x47h.png) > **Note:** How filters are applied depends on the key performance indicator (KPI). For example, date filters can apply to the job completion date or invoice date, depending on the KPI. Hover over a column header in the report to open a tooltip explaining how filters are applied. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-jdeodxt4.png) 4. Click **Run Report**. Your report results display in a table. Use the bottom scroll bar to view additional columns. Use the side scroll bar to view additional rows. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/scrollbar.gif) ## Drill down in reports You can drill down in reports to get additional details: 1. Click an underlined entry you want to drill down into. For example, click an entry in the *Completed Revenue* column. The entry is highlighted. ![Table displaying HVAC services with completed revenue and opportunities for each service.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-bu-dash-revenue-select-entry.png) 2. In the highlighted entry, click **Expand** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-keyboard-arrow-right.png). A table opens in the report showing details for that entry including job and invoice numbers, relevant dates, and more. ![Table displaying HVAC Install revenue, job numbers, and completion dates for various invoices.](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-bu-dash-revenue-expand-entry.png) > [!TIP] > **Tip:** Click a job or invoice number to open the corresponding record in a new tab. ## Edit report columns Your report results appear in a table. You can customize which columns you want to include: 1. Click **Edit Report**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-edit-report-columns.png) 2. On the *Edit Report* screen, select the items you want to add as columns in your report and deselect any items you want to remove. > [!TIP] > **Tip:** Start typing the column name in the search bar to quickly find column options. > > ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-edit-columns-search.png) 3. When you're finished, click **Apply**. 4. To use these columns every time you run the report, click **Save Changes**. 5. Click **Run Report** to see your updated results. If you’re unsure which columns you want to include in your report, use the [Reporting Dictionary](/v1/docs/reporting-dictionary) to search for appropriate data fields. ## Filter and arrange a report You can customize how your report displays and add column filters to narrow down your results: - Interact with column headers to change how the report displays: - Drag a column header to change its order in the report. - Drag a column header and drop it on the bar above the report to group your results by that column. For example, if you drag the *Location City* header, the results group by city name. > [!NOTE] > **Note:** This feature is not available for every column type. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-group-columns.gif) - Drag the right edge of a column header to change the column width. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-column-width.png) - Click a column name to sort the report. For example, click a column of dates to sort the report chronologically. An arrow will show you the sorting order. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-column-sort.png) - To filter a column: - Click **Filter** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-filter-alt.png) next to the column name. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-click-filter-icon.png) - In the filter menu, use the dropdowns and fields to set how you want to filter the column. For example, if you only want to see invoices with a positive value, add a filter to the *Total* column. Select **Is greater than** and enter '0' in the next field. - Use the **And/Or** dropdown to apply multiple filters to a single column. - When filtering a column of percentages, use decimals. For example, for 25%, enter '.25'. - Click **Filter**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-apply-filter.png) The table automatically updates, and the filter icon highlights to show that a filter was applied. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/rd-filter-applied.png) > [!NOTE] > **Note:** *To remove a filter, click* ***Filter*** ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/icon-filter-alt.png) *and click* ***Clear****.* - To keep your filters and other settings for the next time you run the report, click **Save Changes**. ## Export a report You can export your report results to use in spreadsheets and other documents: 1. Above the report results, click **Export**. The *Export Report* pop-up opens. 2. Under *Exporting Format*, select the format of your export: 1. **Export to PDF**: For printing or use in other documents 2. **Export to XLSX**: For use in a spreadsheet application 3. Select **Export only aggregated data** to download just the [aggregated report data](/v1/docs/aggregate-report-data). 4. Click **Export**. ![](https://cdn.document360.io/961862ab-d0f2-4d91-bb62-a62ee8184eff/Images/Documentation/run-filter-and-export-reports-image-cxorvdeu.png) The exported report downloads to your computer. ## --- ### FAQ #### **How do I export customer/job reports to Excel?** Follow the instructions to [export a report](/v1/docs/run-report#export-a-report). You can export a report to PDF or XLSX. #### **Why can't I export or download reports?** Check if your browser blocks pop-ups. It may inadvertently be blocking the download function. #### **Why does my report show less results than expected?** You may have filters set on your report. Clear any active filters. This will show all results. You can then reapply filters individually to make sure you get the results you're expecting. ## Want to learn more? - Visit ServiceTitan Academy to enroll in [Navigating Reports](https://servicetitan.docebosaas.com/academy/learn/courses/377/Navigating-Reports) - See [Schedule custom reports](/v1/docs/schedule-reports)