Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Find the total Post Reply Post New Topic
Author Message
cheecoo
Newbie
Newbie
Avatar

Joined: 03 Jun 2010
Online Status: Offline
Posts: 2
Quote cheecoo Replybullet Topic: Find the total
     Posted: 03 Jun 2010 at 6:31am
Hi there
 
Thus is my frist time to use crystal report, and here i want get a report it has a total, but its not a numbersm its a status such as (open, close, cancelled, solved). in this report i want to find the numbers of the open and the other status.
 
Thank you
cheecoo
Mr. cheecoo
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Jun 2010 at 7:11am
Group on Status
INsert a Summary (sigmna sign button) using the Primay Key Field set as a DistinctCount on group footer
Suppress the details
 
Or use a crosstab in the report header
Columns none
Rows as Satus Field
Summarized Field as PrimayKey field from table Summarized as a DistinctCount
 
 
 
 
 
IP IP Logged
cheecoo
Newbie
Newbie
Avatar

Joined: 03 Jun 2010
Online Status: Offline
Posts: 2
Quote cheecoo Replybullet Posted: 04 Jun 2010 at 4:43am
thanks
 
i will try that
 
hanks bro
 
Mr. cheecoo
IP IP Logged
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