Home arrow Ruby-on-Rails arrow Creating Sales Performance Reports with SugarCRM

Creating Sales Performance Reports with SugarCRM

If your business is successful, it won't take too long for you to have plenty of customers -- and lots of data about them. How do you keep track of it all? With a customer relationship management system, of course. This article will explain how to use the open source SugarCRM to produce an appropriate report. It is excerpted from chapter 8 of the book Practical Reporting with Ruby and Rails, written by David Berube (Apress; ISBN: ISBN: 1590599330).

Author Info:
By: Apress Publishing
Rating: 5 stars5 stars5 stars5 stars5 stars / 3
April 08, 2010
  1. · Creating Sales Performance Reports with SugarCRM
  2. · Updating the Database
  3. · Creating PDFs from HTML Documents
  4. · Dissecting the Code
  5. · Increasing Database Query Performance
  6. · Running the HTML Through Programs

print this article

Creating Sales Performance Reports with SugarCRM
(Page 1 of 6 )

According to Peter Drucker, the famous management consultant, "the purpose of business is to create a customer." The way to create customers is with sales, and when you have a large and active sales force, your salespeople will generate a huge, and often intimidating, amount of customer data. Systems that manage customer data are called customer relationship management (CRM) systems. An excellent choice is an open source product called SugarCRM (http://www.sugarcrm.com/), which is freely available for download and use but also offers paid technical support services.

The example in this chapter demonstrates how to produce a sales performance report with SugarCRM, as well as how to use two open source utilities--html2ps and Ghostscript--to create PDFs from HTML documents.

Installing SugarCRM

To run the examples in this chapter, you'll need to install SugarCRM. You can download SugarCRM from the following site:


At the download site, you'll find two types of installers: the first includes just the SugarCRM source code, which is ideal if you've already installed the Apache/MySQL/PHP stack. If not, installers that combine all of the required components (along with SugarCRM, of course) are available for Linux, Mac OS X, and Windows. Choose the appropriate installer for your system.

After you've downloaded the SugarCRM installer, follow the installation instructions to install SugarCRM. You can download the instructions from this site:


The installer also adds sample data, which you'll use in this chapter's example. Of course, if you already have a SugarCRM database, you can use that data instead.

Sales Force Reporting

Let's suppose your boss has experienced productivity problems with the sales force. In an effort to boost output, he wants to reward productive employees with a gift based on their number of meetings with clients and potential clients. The more meetings a salesperson has, the better the gift.

He would like to keep tabs on this effort, and wants you to produce a report that lists each salesperson and the gift that person has earned. Your boss wants the report to be made available in a format that is easy to print and e-mail. Therefore, you've decided to create the report as a PDF file.

Fortunately, it should be fairly easy to create a Ruby report that pulls this data from the SugarCRM database. First, though, you'll need to modify the database to include the extra gift information.

blog comments powered by Disqus

- Ruby-on-Rails Faces Second Security Flaw in ...
- Ruby 2.0 Prepped for February 2013 Release
- Why LinkedIn Switched from Ruby on Rails
- Adding Style with Action Pack
- Handling HTML in Templates with Action Pack
- Filters, Controllers and Helpers in Action P...
- Action Pack and Controller Filters
- Action Pack Categories and Events
- Logging Out, Events and Templates with Actio...
- Action Pack Sessions and Architecture
- More on Action Pack Partial Templates
- Action Pack Partial Templates
- Displaying Error Messages with the Action Pa...
- Action Pack Request Parameters
- Creating an Action Pack Registration Form

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials