Hi,
I need to build a crystal report that is proving to be a little complicated for my level of expertise and I need help !!
The 3 key fields in the report are job code, pay code, and hours paid. I need to categorize Job code and pay codes into different "TYPES" as per customer's needs. A simple sample below.
Job Types
Job_codes (0612, 0613, 0614, etc ) - "RNs"
Job_codes (0512, 0513, 0514, etc) - "Nurse Asst"
Job_codes (0212, 0213, 0214, etc) - "Mgrs"
Pay Type
Pay_codes (REG, OT, VAC) - "Paid hours"
Pay_codes (REG, OT) - "Worked Hrs"
Pay_code (VAC, JRD) - "Non-worked hours"
Then I need to summarize the total hours paid by the job type for each of the pay types - that looks like a cross-tab.
Here's what I have done so far - I created a formula field for the job type. I used 'if-then-else' to categorize into different types and used the formula field in the cross-tab ROWS. Summarized the hours. So far so good.
But the problem arised with the pay types. I could not use the same logic for the pay type because the pay codes overlap between the types and if-then-else proves inaccurate in this case. Some pay codes may fall under multiple categories.
Do anybody else have any other ideas to handle this? Do you need more details? Please help..
I need to build a crystal report that is proving to be a little complicated for my level of expertise and I need help !!
The 3 key fields in the report are job code, pay code, and hours paid. I need to categorize Job code and pay codes into different "TYPES" as per customer's needs. A simple sample below.
Job Types
Job_codes (0612, 0613, 0614, etc ) - "RNs"
Job_codes (0512, 0513, 0514, etc) - "Nurse Asst"
Job_codes (0212, 0213, 0214, etc) - "Mgrs"
Pay Type
Pay_codes (REG, OT, VAC) - "Paid hours"
Pay_codes (REG, OT) - "Worked Hrs"
Pay_code (VAC, JRD) - "Non-worked hours"
Then I need to summarize the total hours paid by the job type for each of the pay types - that looks like a cross-tab.
Here's what I have done so far - I created a formula field for the job type. I used 'if-then-else' to categorize into different types and used the formula field in the cross-tab ROWS. Summarized the hours. So far so good.
But the problem arised with the pay types. I could not use the same logic for the pay type because the pay codes overlap between the types and if-then-else proves inaccurate in this case. Some pay codes may fall under multiple categories.
Do anybody else have any other ideas to handle this? Do you need more details? Please help..
