Print Page | Close Window

Help with a Bar Chart

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=17202
Printed Date: 02 May 2024 at 1:51am


Topic: Help with a Bar Chart
Posted By: keelan_768
Subject: Help with a Bar Chart
Date Posted: 03 Aug 2012 at 12:24am

Hi,

I have a list of names in a data sheet that I need to do a graph on, there are over 650 names, so I only need to see the name in a bar chart if the name appears more than 3 times onthe sheet (some of them do). I have done a chart but it shows all 650 names. Is there a way I can tel Crystal to only display the name if it appears more than 3 times, this will drmatically reduce the amount of data being shown.
 
many thanks
 
Keelan_768


-------------
keelan_768


Replies:
Posted By: Sastry
Date Posted: 03 Aug 2012 at 8:57am
Hi
 
Using Add command you can get the count into your report and based on the count you can insert a chart.
 
Example :
 
Select Country,Count(Country) from customer group by country having Count(country) > =3
 
 


-------------
Thanks,
Sastry


Print Page | Close Window