• Frustrated with standard reports (no DISTINCT clause), how can we use Enterprise (SQL) reports in dashlets?

    Hello Sugar lovers, We're regularly confronted to the limitations of the standard Sugar Reports module: No HAVING, no DISTINCT, no ability to make calculations... Currently our customers do not want to invest in third pary solutions (Discover and…
  • Chart single color in dashlet, wrong legend

    In v8.0.1 when adding a report to the home dashboard the bar chart is shown in a single color labeled "Home" instead of the multiple colors for the each of the Case statuses. In this image the left is the report as displayed in the dashlet, on the right…