Converting a SugarCRM Report to Another Report Type

SugarCRM’s Reports module allows users to create four different types of reports, each with unique functionality and their own strengths and weaknesses. Have you ever looked at a report and wished it had been created as a different type of report?

The Reports module actually has built-in functionality to help you turn a report of one type into a report of another type with as little work as possible. Simply open a report, and select Duplicate from the action button. Select the type of report you would like to convert the report into. SugarCRM will maintain all of the common settings between the report types, leaving you to fill in only what is distinct or missing for your new version of the report.

For example, SugarCRM version 6.5 came with a system report titled “Pipeline by Team by User.” This summation report gives great high-level information for comparing pipelines by user and team. However, if you want to know more details, such as the breakdown of sales stage or probability for a user’s pipeline, you have to go back and select a different report. What I would like to do is turn this report into a summation with details type of report, so that I can see more details below the chart that I already like to use.

converting a sugarcrm report

When I duplicate as a Summation with Details report, all of my settings are copied. The only thing I will have to do is add what’s new – in this case, what fields do I want displayed in the detail area at the bottom of my report. Once I’ve saved my new report, I can decide whether to keep both reports or delete the original report and use only the new one.

For more information about creating reports in SugarCRM, check out our other blog posts on the topic, and subscribe so that you don’t miss future posts!

Megan Sheehan's picture
Megan Sheehan
Trainer & Business Analyst

Megan is a SugarCRM expert who helps clients design and build their CRM systems. She’s been part of the Technology Advisors team since 2012 and has written three books on SugarCRM in that time. In addition to training clients, Megan co-hosts a SugarCRM focused podcast with Justin called “Sugar Cubed CRM Talk”. She also teaches SugarCRM classes each month. Details about these courses can be found on the Sugar University webpage.

Related Articles

May 29, 2019

At a recent customer event, we were fortunate enough to have Jason from SugarOutfitters come and talk to our customers about his favorite Sugar (and SuiteCRM) add-ons. In this blog post, we’ll share what those top Sugar add-ons were and how you can get your hands on them.

December 21, 2018

A staple role for a Sugar Administrator is the user management within the system. The Admin is responsible for adding and deleting users, managing passwords and login capabilities, and assigning roles and teams appropriately. So, what are the best practices for user management in Sugar? Our SugarCRM experts laid out their recommendations in an online user group. This is a summary of what they discussed.