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
   Unicode Character Sets for SalesLogix Web 8.1
If you have the need to use unicode character sets so international users can view the web client in thei
Posted on Oct 29, 2014 by Mark Duthoy to SalesLogix Support
 
   Video: Demystifying Infor CRM (Saleslogix) Updates
Watch it now! If you missed yesterdays demo, "Demystifying Infor CRM (Saleslogix) Updates" ,
Posted on Sep 26, 2014 by Brianna Ojard to The Inbox
 
   Thoughts on the Future and Involvement in the Saleslogix/Infor CRM Community
Over the last year and a half I've been working on another product named Contatta. It's a great p
Posted on Sep 25, 2014 by Ryan Farley to Ryan Farley's Blog
 
   Fixing the Orphaning of Salesfusion Data when Converting Leads to Contacts in Infor CRM (Saleslogix)
We have had a couple of client recently come to other with the same problem-When you convert a Lead to a
Posted on Sep 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Official Infor CRM Acquisition FAQ
What to expect now that Saleslogix is Infor CRM. Like many of you, it will take some time (probably a
Posted on Sep 18, 2014 by Brianna Ojard to The Inbox
 
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 © 2014 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