Print Page | Close Window

Extracting Dates in a Subreport

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7413
Printed Date: 17 May 2024 at 9:12pm


Topic: Extracting Dates in a Subreport
Posted By: 4milligans
Subject: Extracting Dates in a Subreport
Date Posted: 18 Aug 2009 at 11:35am
I'm STILL working on my payroll reports.  One last hangup and then I think I've got it!  Problem:  When I run this report it's based on a two week pay period.  I'm trying to calculate Overtime (OT) per week.  Right now my OT formula basically says
 
if department. hours > 80 then
department.hours - 80. 
 
The problem is, is that an assoicate can work 42.00 hours (2 hours OT) in one week but only work 16 hours in the second week.  They would not accumulate a  total of 80 hours and therefore not paid the 2 hours of OT they earned in week one.  Make sense?
 
What I need to be able to do is look at each week individually to determine if OT conditions  were met...just not sure how.  I think a subreport will be needed and maybe some date parameters...but I'm really at a loss.  Any help would be appreciated!
 
 
 
 
 


Print Page | Close Window