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

#3474 - Reporting on custom table

Closed Bug? created by jody 5 years ago


We're having some problems with creating a one-to-many relationship between Leads and a custom Leads History module. Our developer wrote:

1: It is not loading relationships correctly (We have created many-to-one relationship for lead History and Leads, but it worked on Many to Many)

2: We can not add Email Address Field (Plugin issue, as per my testing as it is not showing the related fields in email tables)

3: Errors in Log and Report Just Breaks Out with ambiguous queries of report

4: Sometimes report shows nothing, sometimes just Data and sometimes just Chart

What's the best way to get assistance with this problem?

Thanks, Jody

  1. sapiens-bi-primary-contact member avatar

    5 years ago

    Hello Jody,

    Thank you for contacting us! We have contacted you via e-mail in order to solve this together (as we shouldn't share any access details over here in public case ;).

    Best Regards, 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