Print Page | Close Window

Charts with Group Data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22504
Printed Date: 28 Apr 2024 at 7:06pm


Topic: Charts with Group Data
Posted By: wendyb
Subject: Charts with Group Data
Date Posted: 05 Dec 2017 at 5:19am
I have two groups created in my Report.

1) ticket origin (email, phone, self-service,Skype and walk-in)
2) Create Date grouped by Month

I inserted a chart with this group data and it is displaying the data that I want. However, I can't figure out how to have a gap between the months. The bars are all equally spaced regardless and it makes it difficult to determine where one month stops and the next one begins. Is there a way to group the 5 bars for Origin together for each month and have a space between each month?



Replies:
Posted By: DBlank
Date Posted: 07 Dec 2017 at 5:58am
Not entirely following your process but perhaps your issue is that you have a data set that has missing months for different Origins and you want to make sure you show all possible months?
If so the easier answer is to adjust your data set so that you have at a row per month per Origin type. YOU would need nulls for the ticket number field so your counts would not be impacted. Then when you group you don't skip any months.



Print Page | Close Window