Recent content by schaeff

Thank you, that works perfectly! Your time is very much appreciated.

I used the following fields within the Field Explorer to create the running totals: Field to Summarize: leave_time_cards.HRS Type of Summary: sum Evaluate: For each record (radio button) Reset: On each change of group (radio button) Group: GRP#2 Leave_time_cards.HRS-NO The GRP2 field is a...

I was using running totals that are created through the Field Exployer. I was not sure how to create a summary total here since I have a group(leave type) beneath a group(employee). The values in the group header are just fields dragged to the header for convenience. They are not formulas...

I am working in CR XI writing a report against two tables in Excel 2007. My two tables are data extracted from a payroll system and a scheduling system. The tables are linked on Employee ID. The goal is to add up time card records for vacation, sick and personal leave for each employee and...

As I was adding my secondary sort formula to this post I spotted an error I had overlooked. I went back and corrected it and now the sort is working fine. I just couldn't see the problem yesterday and started questioning if I was trying to get CR to do something it wasn't designed to do...

If I sort by Category as my primary sort, then choose Name as my secondary sort I get a result like this: Category Date Loc Code Last Name 7 10/1/2009 10 Littleton 7 11/1/2009 5 Alexander 7 11/5/2009 21 Smith 7 09/4/2009 26 Douglas 9 11/8/2009 5 Williams 9...

I am not sure I understand your question. Are you asking what I see when I open the "Record Sort Expert"? If so, then on the left side of the window is my available fields, on the right side is a list of my sort fields. The top, or first field listed, is my primary sort formula, the second...

Hello, I am using CRXI and have a report that contains information on services. There are a few fields which the users would like control over for sorting such as a service category code, location of service, service date and person name. I have been able to create a primary sort of the...

I want to Thank You lbass. Your soultion was just what I needed! It worked perfectly!

Thank you for your response, however a group selection formula as you suggest would evaluate all hours. So overtime and adjustments would get counted as contributing to the 80 hour total. I really need to exclude any of the hours from my comparison to an 80 pay period that are not standard.

I am attempting to write a report that displays just exceptions for payroll time tracking records. I want to suppress all individuals and all the groups and associated detail records beneath them if they don’t qualify as an exception. An exception is anyone who does not have a total of 80...