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.
2 Answers:
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
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
For 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, Thomas
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
So after writing that query i am anable to query the specified columns
Which column you are unable to get?
Could you just share the JRXML (preferably) or rather a snapshot so that the problem could be better understood