jyothipamarthy Posted May 9, 2013 Share Posted May 9, 2013 I have added table from palette into detail band. when i press preview it generating 150+ pages.I have only 11 records and it fits into one page. How to avoid displaying the other pages. Thanku in advance. Link to comment Share on other sites More sharing options...
Ankur Gupta Posted May 9, 2013 Share Posted May 9, 2013 Hi Jyothi,I think you have placed the table element in the detail band , so for each and every record it runs the table Its advisable to put the table in the summary band. If this is not the case then please check the subdataset for the table , that might be containing some issue. Hope that it helps.Regards,Ankur Link to comment Share on other sites More sharing options...
jyothipamarthy Posted May 9, 2013 Author Share Posted May 9, 2013 hey thanks ankur.. I have tried placing in summary band but now its adding empty pages in the starting.. I have solved this issue by writing SELECT 1 FROM DUAL IN MAIN QUERY Link to comment Share on other sites More sharing options...
jyothipamarthy Posted May 9, 2013 Author Share Posted May 9, 2013 So after writing that query i am anable to query the specified columns Link to comment Share on other sites More sharing options...
Ankur Gupta Posted May 9, 2013 Share Posted May 9, 2013 Which column you are unable to get? Link to comment Share on other sites More sharing options...
Ankur Gupta Posted May 9, 2013 Share Posted May 9, 2013 Could you just share the JRXML (preferably) or rather a snapshot so that the problem could be better understood Link to comment Share on other sites More sharing options...
Thomas Zimmer Posted May 11, 2013 Share Posted May 11, 2013 hey thanks ankur.. I have tried placing in summary band but now its adding empty pages in the starting.. I have solved this issue by writing SELECT 1 FROM DUAL IN MAIN QUERYFor normal, you would not need to do that, you leave the query blank or use it to query the table data. Place your table in the title or summary band, remove the detail (and all othe bands you don´t need), then activate the report setting "When no data = All section, no detail".Cheers, Thomashttp://www.thomaszimmer.net 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