Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: how to sum the HOURS in a group Post Reply Post New Topic
Author Message
yasinirshad
Newbie
Newbie
Avatar

Joined: 24 Sep 2007
Location: Saudi Arabia
Online Status: Offline
Posts: 39
Quote yasinirshad Replybullet Topic: how to sum the HOURS in a group
    Posted: 24 Sep 2007 at 4:23am

Hi,

How to sum up the total of all the HOURS except 'ZZ' which should be summed up seperately.
hope u got me.

Example: (output should be as below).
nadeem    5
shyub       5
ayub         5
ZZirshad   5

Reported Production Hours:     15 (nadeem + shyub + ayub)
Reported NonProduction Hours:  5 (ZZirshad)
 
This report which i have asked now already exists..now i have to modify the report with the changes which i have explained to you above. In the existing report, the record selection formula that exists is,
{HR01.HR01015} like {?Department} and
{EPS_Timesheet_Validation.FNTransactDate} = {?DateRange} and
Switch ({?Non_Productive_Time}='Exclude Non Productive Time',Not ({EPS_Timesheet_Validation.FNProjectNo} like 'ZZ*'),
{?Non_Productive_Time}='Include Non Productive Time',{EPS_Timesheet_Validation.FNProjectNo} like '*',
{?Non_Productive_Time}='Only Non Productive Time',{EPS_Timesheet_Validation.FNProjectNo} like 'ZZ*')
 
Please help me.
Thanks.,
Thanks,
Yasin.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 24 Sep 2007 at 9:20am
You need to create two manual running totals. For the first running total, sum all hours if the Left(FN field},2) <> 'zz'. In the other running total, sum all hours for Left(FN field, 2)='zz'. Then at the end of the report print the two formulas on separate lines.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.016 seconds.