Faça o seguinete, tranforme sua query em uma view e filtre a view por diferente de 0 , como a seguir.
SELECT * FROM
(SELECT
TMOV.DATASAIDA AS DATA,
TLOTEPRD.CODCFO AS COD_PRODUTOR,
TMOV.CODFILIAL AS FILIAL,
UPPER(FCFO.NOME) AS NOME_PRODUTOR,
SUM( TITMLOTEPRD.QUANTIDADE2) AS QUANTIDADE,
SUM ( TITMMOV.VALOROPFRM1 ) AS VOLUMES,
TPRD.CODIGOPRD AS COD_PRO,
TMOV.NUMEROMOV AS DOCUMENTO,
(SUBSTRING (TTMV.NOME,17,40)+' _ '+ TTMV.CODTMV ) AS OPERAÇÃO,
TPRD.NOMEFANTASIA AS DESCRICAO_PRODUTO,
CASE WHEN TLOTEPRDCOMPL.SAFRA IS NULL THEN '--'
WHEN TLOTEPRDCOMPL.SAFRA IS NOT NULL THEN TLOTEPRDCOMPL.SAFRA
END AS SAFRA,
TLOTEPRD.NUMLOTE AS LOTE,
TLOTEPRD.NUMLOTE AS LOTE_TOTAL,
CASE WHEN TMOV.CAMPOLIVRE1 IS NULL THEN '--'
WHEN TMOV.CAMPOLIVRE1 IS NOT NULL THEN TMOV.CAMPOLIVRE1
END AS PROCEDENCIA,
CASE WHEN TLOTEPRD.CAMPOLIVRE1 IS NULL THEN '--'
WHEN TLOTEPRD.CAMPOLIVRE1 IS NOT NULL THEN TLOTEPRD.CAMPOLIVRE1
END AS LOCALIZACAO,
TLINHA.DESCRICAO AS BEBIDA,
TCOLUNA.DESCRICAO AS UMIDADE_PENEIRA,
TCOLUNA.DESCRICAO AS UMID_PEN_TOTAL,
TTMV.CODTMV AS TIPO_MOV
FROM
FCFO, TITMLOTEPRD, TITMMOV, TLOTEPRD, TMOV,TTMV,TPRD,TLOTEPRDCOMPL, TGRADE, TCOLUNA, TLINHA
WHERE
TMOV.CODCOLIGADA='2' AND
TMOV.CODCOLIGADA=TITMMOV.CODCOLIGADA AND
TMOV.CODCOLIGADA=TITMLOTEPRD.CODCOLIGADA AND
TMOV.IDMOV=TITMMOV.IDMOV AND
TITMMOV.IDMOV=TITMLOTEPRD.IDMOV AND
TITMLOTEPRD.NSEQITMMOV= TITMMOV.NSEQITMMOV AND
TLOTEPRD.CODCFO=FCFO.CODCFO AND
TLOTEPRD.IDLOTE=TITMLOTEPRD.IDLOTE AND
TLOTEPRD.CODCOLIGADA=TITMLOTEPRD.CODCOLIGADA AND
TTMV.CODTMV=TMOV.CODTMV AND
TTMV.CODCOLIGADA=TMOV.CODCOLIGADA AND
TPRD.IDPRD=TITMMOV.IDPRD AND
TITMMOV.CODCOLIGADA=TPRD.CODCOLIGADA AND
TLOTEPRD.CODCOLIGADA*=TLOTEPRDCOMPL.CODCOLIGADA AND
TLOTEPRD.IDLOTE*=TLOTEPRDCOMPL.IDLOTE AND
TPRD.CODLINHA IS NOT NULL AND
TPRD.CODCOLUNA IS NOT NULL AND
TGRADE.CODCOLIGADA=TMOV.CODCOLIGADA AND
TGRADE.CODCOLIGADA=TCOLUNA.CODCOLIGADA AND
TGRADE.CODCOLIGADA=TLINHA.CODCOLIGADA AND
TGRADE.IDGRD=TCOLUNA.IDGRD AND
TGRADE.IDGRD=TLINHA.IDGRD AND
TPRD.CODLINHA=TLINHA.CODIGO AND
TPRD.CODCOLUNA=TCOLUNA.CODIGO AND
TGRADE.IDGRD=TPRD.IDGRD AND
TLOTEPRD.IDLOTE =TITMLOTEPRD.IDLOTE
GROUP BY TMOV.DATASAIDA,
TLOTEPRD.CODCFO,
FCFO.NOME,
TMOV.NUMEROMOV,
TTMV.NOME,
TPRD.NOMEFANTASIA,
TPRD.CODLINHA,
TPRD.CODIGOPRD,
TLOTEPRDCOMPL.SAFRA,
TLOTEPRD.NUMLOTE,
TLOTEPRD.CAMPOLIVRE1,
TMOV.CAMPOLIVRE1,
TPRD.CODCOLUNA,
TLINHA.DESCRICAO,
TCOLUNA.DESCRICAO,
TMOV.CODFILIAL,
TTMV.CODTMV)X
WHERE X.QUANTIDADE <> 0
Abraço
Rodrigo Zanetti