What we do
Tools
Industries
Department
How we workLet's talk →
Home/SugarCRM/Sugar Reporting
SugarCRM

Sugar Reporting: Pick the Report Type First, Then the Dashlet and the Email Schedule

The sales manager wants pipeline by rep and stage on the home dashboard, and the same figures in her inbox every Monday. In Sugar that's one report doing both jobs, and the type you choose in the wizard decides how it groups and totals. SugarCRM now brands itself SugarAI, and its help docs have moved to support.sugarai.com.

Which Sugar report type answers your question

The question Report type Watch for
A list of records to work through Rows and Columns, the most basic layout. No grouping or totals. Pick another type if you need sums.
Totals by rep or stage Summation: grouped and summarized. Charts top out at 50 groups, or 16 for a funnel.
Totals, plus the deals behind each one Summation with Details: record-level columns under each group. Detail rows add up fast and can push the report over the large-report limit.
A grid, such as rep by quarter Matrix: row and column totals in one table. Wide grids hit the 30,000-cell large-report limit quickly.
Trends and analytics beyond one report Sugar Discover, included with the Premier+ editions. Sugar's supported-platforms page lists it for SugarCloud instances with SugarIdentity enabled.

Building the Monday pipeline report in Sugar's Reports module

  1. 1

    Open the Report Wizard

    Reports ⋮ Create Report

    Choose the report type and the module it reads, such as Opportunities. The Report Wizard opens.

  2. 2

    Set filters, groups and columns

    Add filters (this quarter, open stages), the group-by fields (assigned user, sales stage), then the columns or summaries to display. Add a chart if the type supports one. Mark a filter as a run-time filter if people should change it on the dashboard.

  3. 3

    Save and Run

    Check the totals against a figure you already trust before anyone else sees it.

    Watch for: tables over 30,000 cells count as large reports. Between 30,000 and 100,000 cells you get a simplified table or a CSV; above 100,000, only the CSV.

  4. 4

    Add it to a dashboard

    Add a Report Dashlet to the dashboard and pick the saved report. It shows the chart and the data table, and a click drills through to the records behind a figure. On the Home dashboard, dashboard filters can change the run-time filters of several dashlets at once.

  5. 5

    Schedule the email

    In the Report Schedules module, create a schedule for the report and choose a PDF or CSV attachment, or results in the email body. You receive it by default; add colleagues through the Users subpanel with Link Existing Record.

    Watch for: the schedule needs your personal outgoing email account, a system mail server, and the Run Report Generation Scheduled Tasks scheduler switched on by an admin.

A scheduled Sugar report that arrives late, chartless or not at all

It never arrived

How you'll know: The schedule is saved, but no email goes out.

Fix: Ask the admin to check three things: your personal outgoing email account, the system mail server, and whether the Run Report Generation Scheduled Tasks scheduler is active.

It arrives hours after the time you set

How you'll know: A report scheduled for 8:00 lands mid-morning.

Fix: Delivery can't run more often than that scheduler does. The admin can shorten its interval.

The chart is missing

How you'll know: The emailed PDF or CSV has the table and nothing else.

Fix: Scheduled PDF and CSV versions don't include charts. Export the report as a PDF from the results view when you need the chart, or point people to the dashlet.

It came as a CSV instead of in the email

How you'll know: You chose results in the body, and got an attachment.

Fix: Reports over 200 rows are attached as CSV. Tighten the filters, or switch to a Summation type.

Revenue and ticket numbers Sugar's reports can't reach

Sugar reports run against Sugar's own modules, standard and custom. If a question needs pipeline next to invoiced revenue from the accounting system, or ticket counts from a help desk Sugar doesn't talk to, someone exports each side and joins them in a spreadsheet. By the time it's cleaned up, leadership is looking at figures from last week.

Two routes fix it. One is to bring the outside figures into Sugar as fields on the account or opportunity through Sugar's REST API, so a normal Summation report can use them. The other is to report from both systems in one dashboard outside Sugar, which also reaches people who aren't on the Report Schedules list, since only Sugar users can be linked there. n-frames builds either one, depending on who reads the numbers.

Sugar reports, dashlets and schedules in detail

Can Sugar's Reports module email reports on a schedule?

Yes, through the Report Schedules module. Results go out as a PDF or CSV attachment, or in the email body, on the interval you set. It depends on a personal outgoing email account, a system mail server and an active report-generation scheduler.

What are dashlets in SugarCRM?

Dashlets are the panels on a Sugar dashboard. A Report Dashlet shows a saved report's chart and data table, supports run-time filters, and lets you drill through to the records behind a figure.

Can a Sugar dashboard show data from outside Sugar?

Not through Report Dashlets, which read Sugar's own modules. Either the outside data is brought into Sugar as fields first, or a separate dashboard reads Sugar and the other system directly.

Does SugarCRM have analytics beyond basic reports?

Yes, by edition. Sugar's pricing lists AI Analytics from Advanced+ up, and Sugar Discover with the Premier+ editions, listed for SugarCloud instances. For figures held in accounting, support or ERP systems, n-frames builds the feed that gets them into Sugar or into one dashboard alongside it.

Who can receive a scheduled Sugar report?

The person who creates the schedule, plus other Sugar users linked to it. People without a Sugar login aren't on that list, which is why finance and operations get a forwarded copy.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.