Articles in this section

Troubleshooting Custom Reports

If you're encountering errors when publishing a custom report, understanding the report type and identifying potential column conflicts is key to troubleshooting. This guide will help you resolve common issues and ensure your reports run smoothly in BigTime Software.

Identifying the Report Type

When a report throws an error, identifying its type is the first crucial step in troubleshooting. Follow these steps to determine it quickly:

  1. If not already there, navigate to the Report Center by selecting Analytics > Report Center from the main navigation bar.
  2. Locate the report, click on it to open, then select the Customize > Edit This Report button to enter the report editor.
                                                                       CustomizeEditReportEmbed.png
  3. Within the editor, initiate the process to add a new column by clicking an existing column and pressing the + button. This action will display a list of available columns.
                              NewColumnEmbed.png
  4. The categories and names of the available columns correspond to specific report types. The examples below show an Activity type report and an Invoice List type report, as specified by the first column group's label.
    ActivityTypeEmbed.png    InvoiceTypeEmbed.png

Note: Both Detail and Summary report types for Time and Expense share the same main headers but differ in key details. For example, Expense Summary reports include Ratio columns, not in the Expense Detail reports, while Timesheet Summary reports feature the "Time vs." section, which is not present in Timesheet Detail reports.

Refer to BigTime's Report Template Glossary for detailed descriptions of each report type and their associated columns.

Avoiding Column Conflicts

Certain columns with similar information can cause errors when included together in a report. For example, including both Payment Type and Last Payment Type in an Invoice List type report can lead to errors upon publishing.

To prevent such issues:

  • Review Column Selections: 
    • Before attempting to republish the report, ensure that selected columns do not overlap in the information they provide.
       
  • Test Incrementally: 
    • Add columns one at a time and test the report to identify any conflicts early.
    • If a Build AI-generated report is breaking, attempt manually re-creating it in the report center.

Duplicate a Report

Creating a copy of a report in BigTime can help refresh a report, and is a straightforward process:

  1. Navigate to Analytics > Report Center and choose the broken report you wish to duplicate.
     
  2. Click the Customize button and select Create a Copy from the dropdown.

                                                                        CustomizeCopyEmbed.png
  3. Click Create Report, assign a new name and folder and attempt to publish the duplicated report. You can now modify this copy without affecting the original.

For detailed guidance on creating and customizing reports, refer to BigTime's Creating Custom Reports article.


Report Customization and Filter Errors

Customization errors can occur when a report's filter settings are incomplete or inconsistent.

Common symptoms include:

  • An error appears when you save or run the customized report
  • A filter you added is missing after you save
  • The report runs, but the results don't match the filters you set

Common Causes

  • An incomplete filter set in the report's customization settings, under Options > Customize Filtering.
  • Filtering Combinations points to the wrong filter. The numbers in a combination such as (1 AND 2) OR 3 follow the order of your filter rows. If you delete a filter, or save one with a blank value, the rows renumber and the combination no longer matches.
  • Filtering Combinations has invalid syntax. For example, a parenthesis is missing its pair. BigTime ignores an invalid combination and applies all filters together using AND, so the report runs but returns rows you didn't expect.

To resolve, follow these steps in order.

  • Step 1:  Open the report and go to OPTIONS > CUSTOMIZE FILTERING.
  • Step 2:  Review each filter row. Every row needs a Column, a Comparison, and a Value. Is Empty and Is Not Empty don't need a value. BigTime removes any row that is missing one of these when you save.
  • Step 3:  Click SHOW FILTERING COMBINATIONS. If the field contains an expression, check the following.
  • Count your filter rows from top to bottom. Each number in the expression must match one of those rows.
  • Check that every opening parenthesis has a closing one.
  • If you don't need to combine filters with OR, clear the field. BigTime then applies all filters together using AND.
  • Step 4:  Click UPDATE REPORT, then run the report again.

Example: Your report has three filters and the combination (1 AND 2) OR 3. You delete filter 2, so your old filter 3 becomes filter 2. The combination still refers to a filter 3 that no longer exists. Change it to 1 OR 2, or to whatever matches what you want the report to return.

If you don't have the right permission, ask your System Administrator to update your rights or adjust the filters for you..

Was this article helpful?
0 out of 0 found this helpful

More Resources