Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a SugarCRM BI plug-in with powerful reporting capabilities, ease of use, elegant design, and a quick and easy setup. This Reporting Tool is easy to use, there is no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports.

Free 30 day trial
Try it Now

By clicking you consent to share your profile with the developer

#3374 - Inaccurate Report Results

Closed Bug? created by jody 5 years ago

Hi, I'm seeing discrepancies between SuiteCRM's native Lead reporting and the results I'm getting in Analytic Reporting. In the system we have one lead with a particular name, say Sandra Smith, and a custom field set to a value of, say, MyForm. In Analytic Reporting, using a simple report with no aggregates or grouping, I see 3 Sandra Smiths, all with the wrong custom field value. I also see a few leads that do not exist at all in the system anymore, even when I filter to exclude recycled and dead leads. Any idea what might be going on or how I might troubleshoot this problem?

  1. sapiens-bi-primary-contact member avatar

    5 years ago

    Hello Jody,

    Analytic Reporting Tool can access all data in your Database, even if they are deleted in Interface while still available in your tables.

    In order to dismiss deleted entries, under tab 'Filters' in your report, please add filter for field 'Deleted' => Unchecked - you should do this for each module in your report.

    If this doesn't help, we should look together at your reports, in this case please send e-mail to for common session scheduling.

    Thank you! IT Sapiens Team

  2. jody member avatar


    5 years ago

    Thanks, this issue has been resolved.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "We have been using it for about a month and it is by far the best available reporting tool for SugarCRM. It is worth spending the time to learn how to use it. "

    Read More Reviews