Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help with a Bar Chart Post Reply Post New Topic
Author Message
keelan_768
Newbie
Newbie
Avatar

Joined: 30 Jul 2012
Online Status: Offline
Posts: 4
Quote keelan_768 Replybullet Topic: Help with a Bar Chart
    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
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.