Search results for query: *

I'm trying to get this formula to return "OK" for the firstrecord of the report and "DUP" if the subsequent records match the previous. Here's where I'm at currently: if ({@Check or Deposit ID}) = previous ({@Check or Deposit ID}) and ({@firstrecord}) = false then "DUP" else "OK"...

Your input is greatly appreciated. I can't wait to try this tomorrow. My apologies for starting multiple threads on this topic, it won't happen again.

I'm doing a report by employee, pay, hours, dues, vacation. I'm currently grouping by employee which results in the pay and hours records being duplicated because for every pay week, there are two records for different due deductions. Will the duplicate hours/pay be removed if I group by...

I'm guessing that my grouping is wrong?

I'm still learning Crystal. I wish that I could do this in Access. Any assistance would be greatly appreciated. I have an if statment to pull the paycheck amts that is based on a deduction called vacation. IF {PRT_CURRENT__CHECK_DEDUCT.Deduction_ID}="UVAC" THEN...

I'm doing a report that requires: Employee, Hours Worked, Pay Received, VacationPay, Dues I have several formulas to get the totals to work on the Group Footer as the Hours Worked and the Pay Received are repeated in the detail. So, I did a count on those fields and divided my total by the...

I'm in a fog and can't figure out how to pull amounts from a table where the id field = dues or uvac. My books arrive tonight, but I thought I'd try. IF {CURRENT_PRT_CHECK_DEDUCT.Deduction_ID}="UVAC" OR "DUES" THEN {CURRENT_PRT_CHECK_DEDUCT.Amount} ELSE 0

Thank you Ibass! I'm making the transition from Access to CR and it's a bit of a learning curve. You were correct, I was placing the formula in the wrong area of the report. I wound up using: If {CURRENT_PRT_CHECK_DEDUCT.Period_End_Date} in MonthToDate Then...

How do I utilize the Last4WeeksToSun formula in a cross tab? I want the "pay_ending_period" field to be limited to last four weeks (actually I wanted last five weeks - but I'll settle for four). I found the Last4WeeksToSun formula and attempted to use it: cross tab expert > column>group...