Carlos Rugno

NOME SALDO_ANTERIOR TOT_ENTRADAS TOTAL_BAIXAS SALDO_ATUAL AA.- 71.91 X 76.27 X 1.35 X 1.14 944,6800 2,0000 2,0000 122701,8160 ABRAC 9MM 9 X 13 001315 944,6800 8,0000 8,0000 122701,8160 ABRACADEIRA DE NYLON PRETA 5X390MM 944,6800 2997,0000 903,0000 122701,8160 ACUCAR REFINADO GUARANI PCT 1KG 944,6800 369,0000 237,0000 122701,8160 ADESIVO INSTANTANEO100G 944,6800 2,0000 1,0000 122701,8160 Saldo anterior e saldo atual - esta agrupando eu gostaria de viesse por item igual TOT_ENTRADAS TOTAL_BAIXAS segue abaixo o script: SET DATEFORMAT dmy; SELECT TPRD.NOMEFANTASIA AS NOME, (SELECT (SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.02', '4.1.01', '4.1.02'))THEN TITMMOV.QUANTIDADE ELSE '0' END)) FROM TMOV left JOIN TITMMOV ON (TITMMOV.IDMOV = TMOV.IDMOV AND TITMMOV.CODCOLIGADA = TMOV.CODCOLIGADA) JOIN TPRD ON (TPRD.IDPRD = TITMMOV.IDPRD AND TPRD.CODCOLIGADA = TITMMOV.CODCOLIGADA) WHERE TMOV.CODCOLIGADA = '1' AND TMOV.CODTMV IN ('1.2.02', '4.1.01', '4.1.02') AND TMOV.STATUS not in ('C') AND TPRD.codigoprd like :Cod_Estruturado AND TMOV.DATAEMISSAO < :DATAINI_D ) - (SELECT (SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.01','4.1.03'))THEN TITMMOV.QUANTIDADE ELSE '0' END)) FROM TMOV left JOIN TITMMOV ON (TITMMOV.IDMOV = TMOV.IDMOV AND TITMMOV.CODCOLIGADA = TMOV.CODCOLIGADA) JOIN TPRD ON (TPRD.IDPRD = TITMMOV.IDPRD AND TPRD.CODCOLIGADA = TITMMOV.CODCOLIGADA) WHERE TMOV.CODCOLIGADA = '1' AND TMOV.CODTMV IN ('1.2.01','4.1.03') AND TMOV.STATUS not in ('C') AND TPRD.codigoprd like :Cod_Estruturado AND TMOV.DATAEMISSAO < :DATAINI_D )AS SALDO_ANTERIOR, SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.02', '4.1.01', '4.1.02') )THEN TITMMOV.QUANTIDADE ELSE '0' END)AS TOT_ENTRADAS, SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.01','4.1.03'))THEN TITMMOV.QUANTIDADE ELSE '0' END) AS TOTAL_BAIXAS, (SELECT (SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.02', '4.1.01', '4.1.02'))THEN TITMMOV.QUANTIDADE ELSE '0' END)) FROM TMOV INNER JOIN TITMMOV ON (TITMMOV.IDMOV = TMOV.IDMOV AND TITMMOV.CODCOLIGADA = TMOV.CODCOLIGADA) INNER JOIN TPRD ON (TPRD.IDPRD = TITMMOV.IDPRD AND TPRD.CODCOLIGADA = TITMMOV.CODCOLIGADA) WHERE TMOV.CODCOLIGADA = '1' AND TMOV.CODTMV IN ('1.2.02', '4.1.01', '4.1.02') AND TMOV.STATUS not in ('C') AND TPRD.codigoprd like :Cod_Estruturado AND TMOV.DATAEMISSAO <= :DATAFIM_D ) - (SELECT (SUM(CASE WHEN(TMOV.CODTMV IN ('1.2.01','4.1.03'))THEN TITMMOV.QUANTIDADE ELSE '0' END)) FROM TMOV INNER JOIN TITMMOV ON (TITMMOV.IDMOV = TMOV.IDMOV AND TITMMOV.CODCOLIGADA = TMOV.CODCOLIGADA) INNER JOIN TPRD ON (TPRD.IDPRD = TITMMOV.IDPRD AND TPRD.CODCOLIGADA = TITMMOV.CODCOLIGADA) WHERE TMOV.CODCOLIGADA = '1' AND TMOV.CODTMV IN ('1.2.01','4.1.03') AND TMOV.STATUS not in ('C') AND TPRD.codigoprd like :Cod_Estruturado AND TMOV.DATAEMISSAO <= :DATAFIM_D ) as saldo_atual FROM TMOV INNER JOIN TITMMOV ON (TITMMOV.IDMOV = TMOV.IDMOV AND TITMMOV.CODCOLIGADA = TMOV.CODCOLIGADA) INNER JOIN TPRD ON (TPRD.IDPRD = TITMMOV.IDPRD AND TPRD.CODCOLIGADA = TITMMOV.CODCOLIGADA) WHERE TMOV.CODCOLIGADA = '1' AND TMOV.CODTMV IN ('1.2.01','4.1.03', '1.2.02', '4.1.01', '4.1.02') aND TMOV.STATUS not in ('C') AND TPRD.codigoprd like :Cod_Estruturado AND tmov.dataemissao BETWEEN :DATAINI_D AND :DATAFIM_D GROUP BY TPRD.NOMEFANTASIA ORDER BY TPRD.NOMEFANTASIA