Ireport report appearing without data

1

I am making a report with Ireport and passing a parameter with date range My sql in report SELECT * FROM venda WHERE data between (venda.data = $P{dataInicial}) AND (venda.data = $P{dataFinal})

However, when testing the report in the preview, I select the interval date at the prompt and come the screen did ..

Does anyone have any ideas?

    
asked by anonymous 03.05.2017 / 04:11

1 answer

1

Or use:

SELECT * FROM venda WHERE data between $P{dataInicial} AND $P{dataFinal};

or use:

SELECT * FROM venda WHERE venda.data >= $P{dataInicial} AND venda.data <= $P{dataFinal};
    
03.05.2017 / 15:00