Good Morning
I am using data from a SQL database, and using CR version 9. I am doing a Human Resources report regarding pay ranges. The minimum of the pay range is whatever the hourly rate is for step 1 of the pay grade. The maximum of the pay range is whatever the hourly rate is for step 2 of the pay grade. I need to put the range in my report from the following fields but an not sure how to get it there. I don't need the step in the report just the hourly rate at step 1 then the hourly rate at step 2 for example:
If the pay grade is 5 and the hourly rate is $8.50 at step 1 and $15.50 at step 2 then it would look like this on the report:
Name Grade Range
Doe, John 5 $8.50 - $15.50
I have a field for the step and a field for the hourly rate. Thanks and if you need more information please let me know.
Vickie
I am using data from a SQL database, and using CR version 9. I am doing a Human Resources report regarding pay ranges. The minimum of the pay range is whatever the hourly rate is for step 1 of the pay grade. The maximum of the pay range is whatever the hourly rate is for step 2 of the pay grade. I need to put the range in my report from the following fields but an not sure how to get it there. I don't need the step in the report just the hourly rate at step 1 then the hourly rate at step 2 for example:
If the pay grade is 5 and the hourly rate is $8.50 at step 1 and $15.50 at step 2 then it would look like this on the report:
Name Grade Range
Doe, John 5 $8.50 - $15.50
I have a field for the step and a field for the hourly rate. Thanks and if you need more information please let me know.
Vickie