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.
#3374 - Inaccurate Report Results
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?
-
"i need to cancel my free trial. and restart it when the DEV environment is more secure" - rogerl
Read More Reviews
- Most Recent Love from Users
jpbievenour- EpconLP
- jason
7 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 info@itsapiens.eu for common session scheduling.
Thank you! IT Sapiens Team
6 years ago
Thanks, this issue has been resolved.