Dont print pages when crosstab report with own dataset have no data

[dretwk]

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 dtendfrom dual[/code]

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 dtendfrom dualwhere exists (select * from crosstabdataset)[/code]

but whether there are other ways?

[hozawa]

Have you tried using subreports for the crosstab? Make sure to match main and sub dataset in the subreport.

[dretwk]

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?