Export to PDF Blank page issue

Hi,
 
I am trying to display the data in two different formats HTML and PDF. In HTML,i want to display 20 rows per each page whereas in PDF as many rows fits the page.
 
For this i have created two tables one for html output and another for pdf. Using visible option i am displaying the tables accordingly.
 
Now, when I ran the report in web viewer it is displaying correctly, but when I export the same output to PDF i am getting blank pages at the end.
 
Report layout is set to "Auto Layout".
 
Note : when i ran with small data ( less than 5000 rows). I didn't see any issue, whereas more than 50000 rows i am facing this issue.
 
Attached is the sample report design as well as xls for datasource.
 
I really appreciate if any one could help in this.
 
Regards
Kishore

Find more posts tagged with

Comments

mwilliams

So, when you run to PDF, you'll be exporting from the web viewer?

rajkishore

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="133936" data-time="1424797992">
<div>
So, when you run to PDF, you'll be exporting from the web viewer?
</div>
</blockquote>
Yes Williams..

mwilliams

Okay. Let me try a few things out. There seems to be an issue with allocated space, which could be a problem. If all else fails, we could always supply a link to rerun the report for PDF so that we can drop the unneeded table to avoid the space issue.

mwilliams

It's looking like the best solution will be to run the report to PDF by a link or button in your report and just hide that link/button in PDF. This would allow you to set the report up for html on first run and when the pdf link/button is clicked from that report, you pass a value through a hidden parameter that will let you know to set the report up for pdf. The blank page issue seems to be a bug. I'll try it out in BDPro/iHub 3.1 to see if it's been fixed and let you know.

rajkishore

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="134014" data-time="1424966235">
<div>
It's looking like the best solution will be to run the report to PDF by a link or button in your report and just hide that link/button in PDF. This would allow you to set the report up for html on first run and when the pdf link/button is clicked from that report, you pass a value through a hidden parameter that will let you know to set the report up for pdf. 
The blank page issue seems to be a bug. I'll try it out in BDPro/iHub 3.1 to see if it's been fixed and let you know.
</div>
</blockquote>
Williams Thanks for your suggestions, it seems it is a fixed length pages(by default 200) issues. i just changed and ran the example report it is working fine.
 
I didn't understand one thing if it is default page issue , why example report which i posted earlier is showing more than 1000+ pages.

rajkishore

I have changed the page limit to 2000. It seems it is working for some extent. But if we add much more data it is failing to generate PDF and not all running.( To replicate this issue add more rows to xls and test)

Any help that would be grateful.

mwilliams

When you change the limit to 2000 the blank pages issue doesn't happen? Now the only issue is the fail to render the PDF with more data?

rajkishore

yes.if the report has more rows and if it exceeds more than 2000pages again the same blank page issue.if the report don't have more than 2000pages then it is fail to rendering to pdf. 
Note: To replicate this, change the limit to 5000pages and add more data to xls.

mwilliams

It's a memory issue. If I make sure my machine has enough free memory and I set the Java virtual machine arguments high enough, the export to PDF with 150000 rows works fine without extra pages. Export limit set to 10000 (I end up with 8200 pages or so).

rajkishore

Appreciate your Help
 
 
Thanks, I have changed JVM arguments It is working as expected in BIRT designer. But it is failed in IHub3 server, Even though i have changed the JVM arguments in acpmdconfig.xml. Do i need to change any more in ihub to work this. I already set proper page limit.
 
Could you exactly tell me where i need to change in acpmdconfig.xml or is there any other file also i need change.

JFreeman

What property did you change the heap size for in the acpmdconfig.xml? You typically should not need to make changes to the JVM start arguments in the acpmdconfig.
 
If you are encountering memory issues when generating a report on the iHub server you will need to change the corresponding heap sizes for the resource group in the acserverconfig.xml.
 
If you are running the report transiently you will need to change the heap size for the Default BIRT Online Resource Group. If you are scheduling the report as a background job you will need to change the heap size for the Default BIRT Factory Resource Group.
 
The acserverconfig.xml is broken down into templates (small, medium and large by default). Make sure that you are changing the heap size on the template your iHub is configured to use. You can check which template is in use with the acpmdconfig.xml.

Sai krishna

<blockquote class="ipsBlockquote" data-author="rajkishore" data-cid="134072" data-time="1425116332">
<div>
Williams Thanks for your suggestions, it seems it is a fixed length pages(by default 200) issues. i just changed and ran the example report it is working fine.
 
I didn't understand one thing if it is default page issue , why example report which i posted earlier is showing more than 1000+ pages. 
</div>
</blockquote>
Hello Raj kishore,
You have said before that you had changed the page limit to 2000. How to change that to export 334 pages into excel sheet. Because when i was exporting it was showing only 200 sheets and skipping the other 134 pages in MS Excel

rajkishore

By default this value is set to 200 pages but it can be configured through a parameter (ALLOW_EXPORT_PAGE_LIMIT) defined in web.xml. 
 
This file can be located in the following folder:

BIRT Report Desinger - [BRDPro Install Dir]\\eclipse\\plugins\\com.actuate.birt.report.viewer_XXXXX\\iportal\\WEB-INF 
BIRT iServer - [BIRT iServer Install Dir]\\servletcontainer\\iportal\\WEB-INF

Sai krishna

<blockquote class="ipsBlockquote" data-author="rajkishore" data-cid="145460" data-time="1475498199">
<div>
By default this value is set to 200 pages but it can be configured through a parameter (ALLOW_EXPORT_PAGE_LIMIT) defined in web.xml. 
 
This file can be located in the following folder:
BIRT Report Desinger - [BRDPro Install Dir]\\eclipse\\plugins\\com.actuate.birt.report.viewer_XXXXX\\iportal\\WEB-INF 
BIRT iServer - [BIRT iServer Install Dir]\\servletcontainer\\iportal\\WEB-INF
</div>
</blockquote>
I have opened that web.xml file using notepad, updated that param value upto 1000 and I had tried to save that file but i am getting a pop-up message as 'Access Denied'. Why i am getting such type of pop-up and what i have to do next if i get such type of pop-up. Thanks in advance.

rajkishore

please check do you have write access to that file.