How to create reports in SugarCRM's Advanced Reporting Function (ReportMaker)

Stella,

A good place to start when learning how to use Advanced Reports is to review our online documentation.  This page goes into detail the different pieces that are needed in order to create an Advanced Report.  You will need to have knowledge of SQL in order to create Advanced Reports.  What I like to do is create a similar report in the Reports module, then show the SQL query for that report by editing the report > Click on Report Details > Check the "Show SQL" checkbox > then click Preview.  The SQL query will be displayed at the bottom of the report results.  Copy the query, then paste in the Advanced Reports Custom Query section and modify to meet your business needs.

Hope this helps,

Lori

i have sugarcrm community edition 6.5.22, How can i get that blue navigation bar

Hi Stella!

The Tenfold blog has a step-by-step guide to creating reports in SugarCRM: https://www.tenfold.com/support-center/sugarcrm-report-of-calls-for-a-user/

Hope this helps you!

Marah Sayaman

Product Support Specialist, Tenfold

Hi Stella!

The Tenfold blog has a step-by-step guide to creating reports in SugarCRM: https://www.tenfold.com/support-center/sugarcrm-report-of-calls-for-a-user/

Hope this helps you!

Marah Sayaman

Product Support Specialist, Tenfold