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.  

Year({HISTORY.COMPLETEDDATE}) > 2005
and
{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


Geo

What's This?
  
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.


Related Content
   Determining User Rights in the Infor CRM (Formerly Saleslogix) LAN Client
I recently had a client ask how to get a query to tell which users have rights to add, edit, and delete v
Posted on Apr 03, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   How do I wrap text in Textboxes in Infor CRM (formerly Saleslogix)?
Recently an Infor CRM administrator contacted me in regards to many of their textboxes for Notes in the I
Posted on Apr 01, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   InforCRM (formerly Saleslogix) Mobile - Clearing Out Earlier Customizations
If you started with an earlier version of SalesLogix Mobile, let's say version 7.5.4, and customized
Posted on Mar 30, 2015 by Mark Duthoy to SalesLogix Support
 
   How do you set the Base Directory when Deploying your Web Client on Infor CRM 8.1?
Question:How do I make sure my Base Directory is set correctly on Infor CRM ? Recently I had a custo
Posted on Mar 06, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   How do I fix a corrupt Picklist in Infor CRM version 8.1?
I had a user ask how to fix a corrupt picklist. The picklist did not show any values when trying to e
Posted on Feb 06, 2015 by Dale Richter to Infor CRM Questions & Answers
 
Comments

 

Preethi said:

Hi,

How did u arrange those lables off to the side?

I am using crystal reports 2008.

Thanks,

preethi

June 21, 2010 4:21 PM
 

George Jensen said:

Preethi

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

Geo

June 23, 2010 3:56 PM
 

Venkata Narasa Reddy kunam said:

Hi

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.

Sebastien

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,

Patrick

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.

THANK YOU!!!

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

(required)  
(optional)
(required)  
Add
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