Repeated Pages issue in ireport

[jyothipamarthy]

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.

[Ankur Gupta]

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

[jyothipamarthy]

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

[jyothipamarthy]

So after writing that query i am anable to query the specified columns

[Ankur Gupta]

Which column you are unable to get?

[Ankur Gupta]

Could you just share the JRXML (preferably) or rather a snapshot so that the problem could be better understood

[Thomas Zimmer]

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

http://www.thomaszimmer.net