Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help with a Report Post Reply Post New Topic
Author Message
ScottEDawg
Newbie
Newbie


Joined: 06 Oct 2007
Location: United States
Online Status: Offline
Posts: 1
Quote ScottEDawg Replybullet Topic: Help with a Report
    Posted: 06 Oct 2007 at 10:32am
I am working in Crystal XI.  I am working with a field that has 2 different acronyms in it for example : OC, and TFC.  I am trying to have the report count all of the OC's and all of the TFC's Seperately but I can't get it to work with the basic summary settings.  Does anybody know a formula I can write to count both of these individually ?  Our DBA will not create a field for each of these so now I'm stuck.  Please Help....Thanx, Dawg
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 06 Oct 2007 at 1:40pm

There are few ways to do this. However for ease you might try creating two Running Totals. One for each of the values you want counted. I would select the field holding the two values and then under evaluate use the formula then put 'OC' and save it as rtOC then do the same for 'TFC' and call it rtTFC. Then place these fields where you want them on the report. In theory this should do what you want.

Regards,

John W.
www.CustomReportWriters.net

 
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.020 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.