Job code Change Report help

[loislane97]

I built a job code change report in Reportsmith that is supposed to return from and to dates for each job code. My 2 sql criteria statements test out fine, and my 2 derived fields test out fine, but when I hit done all I get in return is ORA-00933:SQL command not properly ended. I am not a programmer, so I don't even know where to start looking for how to fix this error. Can anyone help me?

 

[jkgs]

Could be an ODBC driver error. If you can try connecting to Oracle without using ODBC.

John Sakalauskas
VantageIS,LLC

 

[FireGeek21]

I have had this problem before.

You said you are using SQL statements. I assume these are derived fields. Put () around the whole derived field. Next, put a space in front of each line of the SQL - should look like this:

(SELECT P.EMPLID
FROM PS_PERSONAL_DATA P, PS_JOB J
WHERE (( (TO_CHAR(J.EFFDT, 'YYYYMMDD') || J.EFFSEQ = (
SELECT MAX(TO_CHAR(i.EFFDT, 'YYYYMMDD') || i.EFFSEQ)
FROM PS_JOB i
WHERE i.EMPLID = J.EMPLID
AND i.EMPL_RCD_NBR = J.EMPL_RCD_NBR
AND i.EFFDT <= SYSDATE)) AND
(J.EMPL_STATUS IN ('A', 'L', 'S')) ))
)

Notice () around the whole SQL derive field and the space in front of the 2nd and 3rd rows.

Hope that helps.

RSGeek at WI dot RR dot COM