Login / Register  search  syndication  about

          George Jensen's Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Working with the Stacked Bar Graphs in Sage SalesLogix Crystal Reporting

Todays blog post focuses on Crystal Reports stacked bar chart. This chart allows you to use Subgroup totals to make up the group/bar total. This chart is good for showing comparisons between group and subgroup values. The best way to show you this bar chart is to create a quick report using the SalesLogix History table.  You will also need the Picklist table joined to the History table using the HISTORY.TYPE to PICKLIST.ID fields.  I then inserted two fields into the details section of my report, the HISTORY.COMPLETEDDATE and the PICKLIST.TEXT. 

Since there are many types of History records I decided it would be best if I limit my report data.  I inserted the following in the Record Selection Formula Editor launched from the Report > Selection Formulas > Record menu items.  

{PICKLIST.TEXT} in ["E-Mail", "To-DO", "Phone Call", "Meeting"]

This will give me a comparison for this year based on the data from the last four years and limit the type of records to just E-Mails, To-Do's, Phone Calls, Meetings.

Finally we need some the groups and the summary data.  For Group1 I will us the HISTORY.COMPLETEDDATE grouped by year and Group 2 use the PICKLIST.TEXT sorted ascending.  Add a summary to the group 2 footer that provides the count of each type of our selected history records.  This is what my report looks like at this time with the details section suppressed:

In point of view this is the deal, you have the data you need to get your point across but for some reason people seem to really like the eye candy.  So let's get this data into the stacked bar chart. 

So what I did first is suppress all of the sections of my report except the report footer.  I then right clicked on the white space in the report footer and selected Insert Chart from the list that appeared.  Immediately an orange square attached itself to my cursor and I clicked onto the center of the report footer white space, ta-da, a chart appeared.  Again this is the side by side bar chart, to convert to the stacked bar chart I right clicked on the chart and selected the Chart Expert.  When the chart expert opened I selected the chart type of Stacked Bar Chart. I also played around with the values on the text tab to make the report headers make sense.  When you select OK this is the chart you will get.

To add the total for each sub group you can right click on the chart again but this time select the Chart Options from the list.  You will find a tab called Data Labels that will allow you to display the total of each sub group and the total of all records for each year. 

What I really like about this chart is that you can arrange the labels off to the side if they are overlapping each other as you can see I did for the 2010 column of data.  Again Crystal makes it real easy to get your SalesLogix reports looking smart.  Hey, next we will work with the Percentage Bar Chart. Until then, thanks for reading this blog, take care, and keep smilingSmile


What's This?
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.

Related Content
   Can I Bind an Attachment to a Specific Activity in Infor CRM version 7.54?
Recently I had a user ask if they could bind an attachment to a specific Activity within Infor CRM??
Posted on Jul 07, 2015 by Dale Richter to Infor CRM Questions & Answers
   Infor CRM (formerly SalesLogix) Administrator Locked Out
I thought I had seen all the issues affecting the datalink but this was a new one. We could not login t
Posted on Jun 18, 2015 by Mark Duthoy to SalesLogix Support
   How do I remove users from my Infor CRM system (formerly SalesLogix)?
I had an Administrator ask me for the steps they needed to take in order to remove a user from the Infor
Posted on May 08, 2015 by Dale Richter to Infor CRM Questions & Answers
   Infor CRM (Formerly Saleslogix) v8.1 update 03 and 05- Uncaught Error Scheduling Contact Processes
 In the Infor CRM (formerly Saleslogix) web client, under the Contact area you have the ability to s
Posted on May 07, 2015 by Kris Halsrud to Kris Halsrud's Blog
   Problem Showing All Area, Category, and Issue Values in Infor CRM (Saleslogix) Mobile And How to Fix
There is an issue with the Infor CRM (Saleslogix) Mobile client where, if you have a large list of Area,
Posted on Apr 24, 2015 by Ryan Farley to Ryan Farley's Blog


Preethi said:


How did u arrange those lables off to the side?

I am using crystal reports 2008.



June 21, 2010 4:21 PM

George Jensen said:


They are just report fields so I dratged them to where I thought they would work best.


June 23, 2010 3:56 PM

Venkata Narasa Reddy kunam said:


Thanks for posting this Article.  

July 15, 2010 2:38 AM

Seabass said:

Great article Thanks !

Is there a way to locked the color use for each risers on the graph ? I changed the color for the risers themselves so it is more representatives of what i want to show... theproblem is that when i export into pdf, the color switch to the original one.... In this case red to green when we really want to show the opposite.

Any help or tips would be appreciated.


March 31, 2011 8:36 AM

Patrick said:

Thanks for the article. It is great.

Just one quick question:

In each bar of your bar chart, you display types in the order "To_do", "phone call", "meeting" and "email". How can we rearrange them so they will be displayed in a order like "phone call", "to_do", "email" and then "meeting"?

Thanks a lot,


June 9, 2011 11:53 PM

carleen said:

Thank you for posting this.  

I'm a newbie, I've never created a Crystal Report from scratch, much less using Groupings.  

Once I found your article, I was done within 10 minutes.


December 12, 2011 2:40 PM

Varinder Bansal said:

Great Artide. i am in tension from last 5 days and found no solution for creation of Stacked Bar chart. but with your article i finally crack this.

Thanks Alot.

April 15, 2012 4:21 AM

Varinder Bansal said:

Can u Plz help me in creating Pie Chart also. i also need help in this regards.

Thanks in advance.

April 15, 2012 4:27 AM

Leave a Comment

All contents Copyright © 2015 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register