dretwk Posted August 5, 2015 Share Posted August 5, 2015 I have report with main report query that return one row alwaysselect 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? Link to comment Share on other sites More sharing options...
hozawa Posted August 5, 2015 Share Posted August 5, 2015 Have you tried using subreports for the crosstab? Make sure to match main and sub dataset in the subreport. Link to comment Share on other sites More sharing options...
dretwk Posted August 5, 2015 Author Share Posted August 5, 2015 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now