I have report with main report query that return one row always
SELECT to_date($P{param0},'yyyy-mm-dd HH24:MI:SS') AS dtstart, to_date($P{param1},'yyyy-mm-dd HH24:MI:SS') AS dtend FROM dual
In detail bands I have crosstab reports, that have own datasets, when crosstab dataset dont return data, iReport print blank page but in report property "When no data"="NoPages", how to avoid it and dont print blank page. I know one method for this use crosstabs query in main query how in this example:
SELECT to_date($P{param0},'yyyy-mm-dd HH24:MI:SS') AS dtstart, to_date($P{param1},'yyyy-mm-dd HH24:MI:SS') AS dtend FROM dual WHERE EXISTS (SELECT * FROM crosstabdataset)
but whether there are other ways?
2 Answers:
Posted on August 5, 2015 at 1:35am
What did you mean match main and sub dataset in the subreport, can you describe please?
I rephrase the question I'm need, that if subreports dont return data, a main report should not print blank page...
As I understood the decision at the report level does not exist, and I m need to use subreport query in main query?