Prezados boa tarde,
Fiz uma planilha pra trazer os dados de pensão, só que qdo faço a inserção do Filtro na Planilha dá erro.Estou na versão Delphi e não utilizo máquina de cálculo.Alguem pode ajudar ?Obrigado e abaixo a SQL
SELECT A.CHAPA, B.NOME, D.PERCENTUAL ||'%' ||C.NROVEZES ||'x' AS TOTAL_PERCENT, D.RESPONSAVEL, (SELECT NVL(F.VALOR,0) FROM PFFINANC F WHERE F.CHAPA=A.CHAPA AND F.MESCOMP=:PLN_Sheet1!$C$1_V AND F.ANOCOMP=:PLN_Sheet1!$C$2_V AND F.CODEVENTO='0123') AS EVENTO_UM, (SELECT NVL(F.VALOR,0) FROM PFFINANC F WHERE F.CHAPA=A.CHAPA AND F.MESCOMP=:PLN_Sheet1!$C$1_V AND F.ANOCOMP=:PLN_Sheet1!$C$2_V AND F.CODEVENTO='0137') AS EVENTO_DOIS, (SELECT NVL(F.VALOR,0) FROM PFFINANC F WHERE F.CHAPA=A.CHAPA AND F.MESCOMP=:PLN_Sheet1!$C$1_V AND F.ANOCOMP=:PLN_Sheet1!$C$2_V AND F.CODEVENTO='0187') AS EVENTO_TRES, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_V AND P.INCPENSAO=1 AND M.NRODEPEND=1) AS DEP_I, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_V AND P.INCPENSAO=1 AND M.NRODEPEND=2) AS DEP_II, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_V AND P.INCPENSAO=1 AND M.NRODEPEND=3) AS DEP_III, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_v AND P.INCPENSAO=1 AND M.NRODEPEND=4) AS DEP_IV, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_V AND P.INCPENSAO=1 AND M.NRODEPEND=5) AS DEP_V, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_v AND P.INCPENSAO=1 AND M.NRODEPEND=6) AS DEP_VI, (SELECT NVL(M.VALOR,0) FROM PFDEPMOV M INNER JOIN PFDEPEND P ON (((P.CHAPA = M.CHAPA) AND (P.CODCOLIGADA = M.CODCOLIGADA) AND (P.NRODEPEND = M.NRODEPEND))) WHERE M.CHAPA=A.CHAPA AND M.MESCOMP=:PLN_Sheet1!$C$1_V AND M.ANOCOMP=:PLN_Sheet1!$C$2_V AND P.INCPENSAO=1 AND M.NRODEPEND=7) AS DEP_VII FROM PFFINANC A INNER JOIN PFUNC B ON ((B.CODCOLIGADA = A.CODCOLIGADA) AND (B.CHAPA = A.CHAPA)) INNER JOIN PFCODFIX C ON ((C.CODCOLIGADA = A.CODCOLIGADA) AND (C.CHAPA = A.CHAPA)) INNER JOIN PFDEPEND D ON ((D.CHAPA = B.CHAPA) AND (D.CODCOLIGADA = B.CODCOLIGADA)) WHERE A.MESCOMP=:PLN_Sheet1!$C$1_V AND A.ANOCOMP=:PLN_Sheet1!$C$2_V AND A.CODEVENTO IN ('0123','0137','0187') AND D.PERCENTUAL IS NOT NULL AND D.INCPENSAO=1 GROUP BY D.RESPONSAVEL, A.CHAPA, A.CODEVENTO, B.NOME, C.NROVEZES, D.PERCENTUAL, D.NOME ORDER BY B.NOME, D.RESPONSAVEL