Sapiens.BI helps you produce effective reports with charts in a fast and easy way. It is a Sugar and SuiteCRM 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.
#1047 - One to Many is not linking properly
I have two custom entities.
Widgets WidgetStatistics
Where Widget has many WidgetStatistics
I've making Widget as the main with the WidgetStatistics as the secondary And the reverse.
In both cases there is no option of WidgetStatistics.WidgetID = Widget.ID
When I run the report, whichever entity is the secondary has no data in the columns.
-
"Such a great tool. Everything works fine."
Read More Reviews
- Most Recent Love from Users
lodevlayen- Nesterovaelenav
- carlort
6 years ago
Thank you for contacting us!
You should try using 'Many-to-many' relationship type instead of 'On-to-many'. This sounds misleading, but is quite common solution, due to the fact that in most cases by default SuiteCRM creates many-to-many relationship in the DB, in spite of the fact, that actually you just need one-to-many.
Please let us know, if this solves the issue. Otherwise we can schedule a common session with our IT Support and then solve this together ;).
Best Regards, IT Sapiens Team