Support CenterReports showing zeros for totals
🔍 Reports showing zeros for totals
This guide explains common reasons totals may show as zero in SureFire reports and how to restore missing database information.
⚠️ Before You Begin
Before you start, make sure you are working with the most recent version of SureFire and that your report date filter is set correctly.
🧩 Why Totals May Show as Zero
This may result from running an older version of a report that has been updated. Make sure you are running the most recent version of SureFire.
This could also result from database records with empty Created date fields. The report filter will omit these returns if the Date filter criteria is set to Created. You can try running the report with the Date report criteria field changed to something like Edited or Accepted to see if the correct totals show.
Finally, database information could simply be missing. To resolve this problem, re-process your acknowledgements and then run the DBRepair.exe file with the Populate DB from Returns option checked.
🛠️ To Restore Database Information
Step 1: Re-process your acknowledgements
Use this when you need to refresh acknowledgements so the database can be repopulated correctly.
Re-process your acknowledgements by selecting the Communications menu, and then clicking Get Acks, Mail and Updates.
When the process is complete, click Close in the Electronic Filing Center dialog box.
Step 2: Close SureFire
Use this before running DBRepair.exe to avoid conflicts with open application files.
Close SureFire.
Step 3: Open Windows Explorer
Use this to locate the DBRepair.exe file for your tax year.
Right-click the Start button, and then click Open Windows Explorer.
Step 4: Navigate to the DBRepair.exe folder
Use this to find the correct DBRepair.exe for your SureFire installation and tax year.
Navigate to the X:\UTSXX (where X: corresponds to the drive where SureFire is installed, and XX corresponds to the tax year of your program) directory, and then double-click the DBRepair.exe file.
Step 5: Populate the database from returns
Use this to repopulate missing database information so totals can calculate correctly.
In the DB Repair window, select the Populate DB from Returns check box.
Click Start repair.
When the repair process is complete. close the DB Repair window.
Step 6: Confirm the issue is resolved
Use this to verify that your report totals are no longer showing zeros.
Open SureFire and confirm that the problem has been resolved. If not, contact Customer Service at 866-641-9473.
📞 Still Need Help?
If you are having trouble, contact our support team:
Phone: 1-800-516-9442
Tags: diagnostic,install,setup