Search results for query: *

The following is my formula in the @union if isnull({PR_Time_Card_History_MC.Union_Code}) then "" else ( select mid({PR_Time_Card_History_MC.Union_Code},2,1) case "D" : "Driver" case "O" : "Operator" case "L" : "Laborer" case "F" : "Foreman" ); if {PR_TIME_CARD_HISTORY_MC.Union_Code} =...

Did not work. The work class is actually the union code converted to text. if isnull({PR_Time_Card_History_MC.Union_Code}) then "" else ( select mid({PR_Time_Card_History_MC.Union_Code},2,1) case "D" : "Driver" case "O" : "Operator" case "L" : "Laborer" case "F" : "Foreman" ) If I attempt...

Below is how my report is displaying. I need to combine all the driver hours into a total. I have tried sum, total and I must not be using the right codes, as it gives me a total underneath the individual total. Period_End_Date Race Job_Number WorkClass Hours 5/28/2011 C...

Forgot to put in and. Thank you

I have set up my parameters to prompt in crystal, but I actually need it to prompt withing Spectrum. The Spectrum prompt is only changing, if I go into Crystal and change the criteria from within Crystal. Can anyone tell me how to make this work? Thanks,

Fixed this one :)

Good morning :) The formula did exactly what I needed it to do, but it disrupted my parameters. It is completely ignoring my parameters and returning every record clear back to 1999. The parameters were set for period end date 10/15/11 - 10/15/11 and job 4250. Thank you,

Hello; I need to have certain information from my report to not pull and I am not sure how to do this. I have Union Codes that I am pulling the data from which is a 4 digit / letter code SO32. If it is less than 4 characters, I do not want it to pull? Can someone help me with the code to...

Thank you, the hours are back to what they should be.

Nothing in evaluation section rts = reset groups are in order The RTS are in group#3

Groups PR_Employment_utilization_MC.job_Number-A PR_Employment_utilization_mc.employee_code_A PR_Employment_utilization_MC_EEO_class_code-A Running totals: sum RTotal0 PR_Employement _Utilization _MC.Male_hours_list1 RTotal1 PR_Employement_Utilization_MC.Female_hours_list1 on change of...

I am new at this and need a little guidance as to where I would locate the grouping. If I go to grouping there is nothing.

No the race id is purely to show the ethnicity for minority reporting purposes. Group footer #3 pr_employment-utilization_mc.eeo_class_code-A employeecode1: pr_employment_utilization_mc.employee employeename1: pr_employment_utilization_mc.employee SSN1: @ssn Hours1:@hours Sex1: @ Sex raceId1...

Well, my report looks great except when I added the race id string it increased my running total for hours. I am using the following for my total hours - {#RTotal0} + {#RTotal1} I have tried multiple formula's to get it to only count the race id row once to no avail. Any help would be...

Thank you, I had the second part with the 2 and the cases, but did not have the one or the first line.

We have six specific codes I need to convert. If I am understanding you correctly, I am using the PR_Time_Card_History_MC.Union_Code as my table. The second position is the key to their labor code. If it is L it is Laborer, if it is D it is driver, if it is O it is operator. Thank you, for...

I am trying to convert thousands of union codes to reflect their labor class. The second letter of each code dictates what their labor code is. if the code is CL0532 I need it to return Laborer. Can someone please help? Thanks