Repeated Pages issue in ireport

0

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.

jyothipamarthy's picture
Joined: May 1 2013 - 2:51am
Last seen: 6 years 6 months ago

2 Answers:

0

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

Ankur Gupta's picture
Joined: Jan 21 2013 - 10:36pm
Last seen: 2 months 2 days ago

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 - 6 years 6 months ago

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

jyothipamarthy - 6 years 6 months ago

Which column you are unable to get?

Ankur Gupta - 6 years 6 months ago
show 1 more...

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

Ankur Gupta - 6 years 6 months ago
0

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

Thomas Zimmer's picture
Joined: Oct 2 2012 - 1:35am
Last seen: 5 days 12 hours ago
Feedback