9. Reports
Summary Collection Report

Scenarios where the issue occurs:-

The Scenarios where this issue can occur is as follow:

  • Unable to view Summary Collection Report in iCM
How to Identify the issue:-

Steps that help us to identify the issue are as follows:

  • Unable to view Summary Collection Report in iCM
  • All other reports are visible correctly.
Solution Provided:-

Steps to resolve the issue are as follows:

  1. It is related to database corruption.
    1. First try “Compact and Repair” feature of Ms-Access, see if the issue gets resolved if not go to below given steps
  2. Now open database and check tReportDts table it could be corrupted or missing.
    1. Delete this table and copy from any other correct database and paste it on to the problematic database, selecting structure and data.

Above mentioned steps can resolve the issue.

Summary Collection Report depends on database size. If database size is large this report will take time to be visible and vice versa since it shows the summary of collection from calendar date 1st to till the date.
A fresh database where there is no entry can let us show Summary Collection Report immediately or number of days are less for which this report is being generated.