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
   Mobile 3.0.3 for Saleslogix v7.5.4, v8.0.0 & v8.1.0 is now available!
Saleslogix Mobile v3.0.3 is now available in the customer portals. This update addresses all issues int
Posted on Apr 14, 2014 by Scott Weber to SalesLogix Product Blog
 
   Editing Filters in Saleslogix Web Client 8.0
Is it possible to add or remove Saleslogix filters from the List view in Accounts?
Posted on Apr 08, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
   Creating a Unique Saleslogix table ID in a SQL Function
A couple of months ago Ryan Farley wrote an article about how to use a SQL stored procedure to create a S
Posted on Mar 25, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix Integration with Google - WOW!
Saleslogix will be releasing their Google Integration this month and from what I have seen, it is fantast
Posted on Mar 18, 2014 by Scott Weber to SalesLogix Product Blog
 
   Global Joins in the Saleslogix Web Client
Question: How can I make a Global Join stick in the Saleslogix Web Client? Currently, when I create a
Posted on Mar 07, 2014 by SalesLogix Support to SalesLogix 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 © 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