Skip to Content
0
Former Member
Dec 05, 2008 at 07:06 PM

Don't know where to start...

25 Views

I'm new to Crystal Reports....

I want to create a report those the min, midpoint and max salary of every position.

I use the position table and salary table. Our salary table is set up with a each Grade having steps 1-16 with a corresponding rate. Mininum would be step 1, midpoint would be step 8 and max would be step 16.

I want the report to look like this:

Position Number Position Name Grade Step 1 Step 8 Step 16

555-55555 Secretary 12 10.01 12.01 13.01

I can get the first three columns ok but I can't seem to get the rates Ok. I tried using a formula but I am getting TRUE/FALSE answers instead of the actual rates.

Can anybody point me in the right direction?