Change your query from : WHERE PES.PES_NOME = $P{Nome} to: WHERE $X{IN,PES.PES_NOME,Nome} do the same for other parameters where input is not required Or just simply change AND to OR WHERE (PES.PES_NOME = $P{Nome}or PFI.PFI_SEXO = $P{Sexo} or PFI.PFI_CPF = $P{CPF})