Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: How to Count in Crystal Report with where Statemen Post Reply Post New Topic
Author Message
akocjhepoii
Newbie
Newbie
Avatar

Joined: 16 Oct 2012
Location: Philippines
Online Status: Offline
Posts: 1
Quote akocjhepoii Replybullet Topic: How to Count in Crystal Report with where Statemen
    Posted: 16 Oct 2012 at 11:44pm
Anyone knows how to count record in crystal report with exception ? i want to do my report like this .

GroupName---Leader---No of Mem----Total----Grand Total
BOMB        Resty       5
BOMB        Roel        4              
                                    9
FireWork    Osvi        5           
FireWork    Waffu       6            11
                                               20

But there is an exception . if the member of the Leader has INC in the last 3 letters of his name he wouldnt count . it will be disregard.
Signature
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Oct 2012 at 3:49am
use a running total with an evaluation formula (or use shared variable formulas that do the same thing)
 
right click on Running Total ans selcet new
Name=whatever
Field to summarize=number of member field
type = sum
evaluate=use a formula
right(table.name,3)<>'INC'
reset=on change of group (for group totals)
place in group footer
--RTs do not work in headers
 
Repeat a seonc RT for the grand total but make the reset=never
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.