Print Page | Close Window

Summary Question

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17555
Printed Date: 05 May 2024 at 2:01pm


Topic: Summary Question
Posted By: Subway2271
Subject: Summary Question
Date Posted: 12 Sep 2012 at 11:21am
I have two options (Free and Billed) inside of a database field (Incident.SLA).  I need to be able to get a total number of how many incidents are Free and how many incidents are billed?  I am new to crystal and stuck?  Any help would be greatly appreciated!!


Replies:
Posted By: dbodell
Date Posted: 16 Sep 2012 at 8:53am
Easy: create a formula called Billed and a formula called Free. In the Billed formula do the following:
If Incident.SLA = "Billed" then 1 else 0
 
For the Free formula:
If Incident.SLA = "Free" then 1 else 0
 
Put these fields into your detail section. Then insert a summary on each of the formula fields. Then you will have the number of instances where the field said  "Billed" and the number of instances where the field said "Free:. There are probably a dozen ways to do this, but this is the most straightforward one I could think of.


-------------
Thanks,
D. Bodell


Print Page | Close Window