You "may" have to additionally set a FLAG: COMPUTE OT_FLAG/A1 = IF TOT_OT NE 0 THEN 'Y' ELSE 'N'; NOPRINT
ON PS_WHATEVER SUBHEAD
"SUN<+0>MON<+0>Tue<+0>"
Then the report has 9 lines for the 9 different paycodes:
"<PS_LN1_PAYCODE <PS_LN1_SUN <PS_LN1_MON <PS_LN1_TUE"
WHEN TOTAL TOT_RG NE 0;
This is Regular Time
"<PS_LN2_PAYCODE <PS_LN2_SUN <PS_LN2_MON <PS_LN2_TUE "
WHEN TOTAL TOT_OT NE 0;
or
WHEN OT_FLAG EQ 'Y';
This is Paid OT
"<PS_LN3_PAYCODE <PS_LN3_SUN <PS_LN3_MON <PS_LN3_TUE "
This is Personal Time
You get the idea...
Hope this helps..
TomThis message has been edited. Last edited by: Tom Flynn,
After I could not get the computes to work I inquired with my DBA as to why. He said the values (hours) I see in the view, say 7.6 are no longer decimal values. He is converting them in the view to varchars.
He said I just need to check the first field "LN2.PAYCODE" for a value (POT, paid overtime). If there is no vaule (NULL), THEN NOPRINT.
This line:
IF LN2.PAYCODE EQ 'NULL' NOPRINT
gives me a parsing error.
prod: WF 7.7.03 platform IIS on Windows 2007, databases: Oracle, , MSSQL
February 26, 2009, 12:32 PM
Tom Flynn
Yep, I don't think anyone puts a NOPRINT on data tests...Well, I thought not.
Hold the data, excluding blank or MISSING PAYCODE, then, report from the HOLD file...
This isa bit convoluted for a labeling report but it could be modified and used for your problem /* LINE2/A255=IF NameAndTitle GT '' THEN NameAndTitle_UPPER ELSE IF REPRESENTING GT '' THEN REPRESENTING_UPPER ELSE IF COMPANYNAME GT '' THEN COMPANYNAME_UPPER ELSE IF TRADINGASNAME GT '' THEN TRADINGASNAME_UPPER; LINE2IND/A1=IF NameAndTitle GT '' THEN 'N' ELSE IF REPRESENTING GT '' THEN 'R' ELSE IF COMPANYNAME GT '' THEN 'C' ELSE IF TRADINGASNAME GT '' THEN 'T'; LINE3/A255=IF (REPRESENTING GT '' AND LINE2IND NE 'R') THEN REPRESENTING_UPPER ELSE IF (COMPANYNAME GT '' AND LINE2IND NE 'C') THEN COMPANYNAME_UPPER ELSE IF (TRADINGASNAME GT '' AND LINE2IND NE 'T')THEN TRADINGASNAME_UPPER ELSE IF ADDRESS1_UPPER GT '' THEN ADDRESS1_UPPER; LINE3IND/A1=IF (REPRESENTING GT '' AND LINE2IND NE 'R') THEN 'R' ELSE IF (COMPANYNAME GT '' AND LINE2IND NE 'C') THEN 'C' ELSE IF (TRADINGASNAME GT '' AND LINE2IND NE 'T')THEN 'T' ELSE IF ADDRESS1_UPPER GT '' THEN 'A'; LINE4/A255=IF (COMPANYNAME GT '' AND LINE3IND NE 'C') THEN COMPANYNAME_UPPER ELSE IF (TRADINGASNAME GT '' AND LINE3IND NE 'T')THEN TRADINGASNAME_UPPER ELSE IF (ADDRESS1_UPPER GT '' AND LINE3IND NE 'A') THEN ADDRESS1_UPPER ELSE IF ADDRESS2_UPPER GT '' THEN ADDRESS2_UPPER ELSE CITY_UPPER ||''|STATE1 |' '|ZIPCODE1; LINE4IND/A1=IF (COMPANYNAME GT '' AND LINE3IND NE 'C') THEN 'C' ELSE IF (TRADINGASNAME GT '' AND LINE3IND NE 'T')THEN 'T' ELSE IF (ADDRESS1_UPPER GT '' AND LINE3IND NE 'A') THEN 'A' ELSE IF ADDRESS2_UPPER GT '' THEN '2' ELSE 'Z'; LINE5/A255=IF LINE4IND EQ 'Z' THEN '' ELSE IF (TRADINGASNAME GT '' AND LINE4IND NE 'T')THEN TRADINGASNAME_UPPER ELSE IF (ADDRESS1 GT '' AND LINE4IND NE 'A' AND LINE4IND NE '2' AND LINE4IND NE 'Z') THEN ADDRESS1_UPPER ELSE IF (ADDRESS2 GT '' AND LINE4IND NE '2' AND LINE4IND NE 'Z') THEN ADDRESS2_UPPER ELSE IF LINE4IND NE 'Z' THEN CITY_UPPER ||''|STATE1 |' '|ZIPCODE1 ELSE ''; LINE5IND/A1=IF LINE4IND EQ 'Z' THEN 'Z' ELSE IF (TRADINGASNAME GT '' AND LINE4IND NE 'T')THEN 'T' ELSE IF (ADDRESS1 GT '' AND LINE4IND NE 'A' AND LINE4IND NE '2' AND LINE4IND NE 'Z') THEN 'A' ELSE IF (ADDRESS2 GT '' AND LINE4IND NE '2' AND LINE4IND NE 'Z') THEN '2' ELSE IF (CITY GT '' AND LINE4IND NE 'Z') THEN 'Z' ELSE 'X'; LINE6/A255=IF LINE5IND EQ 'Z' THEN ' ' ELSE IF (ADDRESS1 GT '' AND LINE5IND NE 'A' AND LINE5IND NE '2' AND LINE5IND NE 'Z') THEN ADDRESS1_UPPER ELSE IF (ADDRESS2 GT '' AND LINE5IND NE '2' AND LINE5IND NE 'Z') THEN ADDRESS2_UPPER ELSE IF LINE4IND NE 'Z' THEN CITY_UPPER ||''|| STATE1 |' '|ZIPCODE1 ELSE ''; LINE6IND/A1=IF LINE5IND EQ 'Z' THEN 'Z' ELSE IF (ADDRESS1 GT '' AND LINE5IND NE 'A' AND LINE5IND NE '2' AND LINE5IND NE 'Z') THEN 'A' ELSE IF (ADDRESS2 GT '' AND LINE5IND NE '2' AND LINE5IND NE 'Z') THEN '2' ELSE IF (CITY GT '' AND LINE5IND NE 'Z') THEN 'Z' ELSE 'X'; LINE7/A255=IF LINE6IND EQ 'Z' THEN '' ELSE IF (ADDRESS2 GT '' AND LINE6IND NE '2' AND LINE6IND NE 'Z') THEN ADDRESS2_UPPER ELSE IF LINE6IND NE 'Z' THEN CITY_UPPER ||''|| STATE1 |' '|ZIPCODE1 ELSE ''; LINE7IND/A1=IF LINE6IND EQ 'Z' THEN 'Z' ELSE IF (ADDRESS2 GT '' AND LINE5IND NE '2' AND LINE5IND NE 'Z') THEN '2' ELSE IF (CITY GT '' AND LINE5IND NE 'Z') THEN 'Z' ELSE 'X'; LINE8/A255=IF LINE7IND EQ 'Z' THEN '' ELSE IF LINE7IND NE 'Z' THEN CITY_UPPER || ' '|STATE1 |' '|ZIPCODE1 ELSE ''; LINE8IND/A1=IF LINE7IND EQ 'Z' THEN 'Z' ELSE IF (CITY GT '' AND LINE5IND NE 'Z') THEN 'Z' ELSE 'X'; /*
Bob
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit