Home
Analytics
BIRT Viewer Toolkit - Exporting Content - configurable?
richardcooper25
<p>Hi,</p><p> </p><p>I am trying out the BIRT Viewer Toolkit and have a few questions regarding Exporting Content of reports:</p><p> </p><p><strong>Scenario: Report designed to export to one Excel worksheet (i.e. one page)</strong></p><p>The report displays correctly in the viewer in the browser and in my case has 271 pages in HTML format.</p><p> </p><p style="margin-left:40px;">a.) If I select 'Export Content' and select <strong>Excel (XLS) </strong>as the Export Format, a dialog box pops up with:</p><p style="margin-left:40px;"><em>"<span>This report exceeds the max export page count limit. Only the first 200 of pages are exported."</span></em></p><p style="margin-left:40px;">If I select 'Yes', the report exports to one Excel work sheet but with data missing (for the last 71 pages)</p><p style="margin-left:40px;"> </p><p style="margin-left:40px;"><strong>How can I increase or override the page limit?</strong> (There shouldn't be a page limit going into one worksheet and this is not an issue with the standard BIRT Viewer).</p><p style="margin-left:40px;"> </p><p style="margin-left:40px;">b.) If I select 'Export Content' and select <strong>Excel (XLSX) </strong>as the Export Format, a dialog box pops up with:</p><p style="margin-left:40px;"><em>"<span>This report exceeds the max export page count limit. Only the first 200 of pages are exported."</span></em></p><p style="margin-left:40px;">If I select Yes, the report exports to multiple Excel work sheets (one per page) and also with data missing (for the last 71 pages)</p><p style="margin-left:40px;"> </p><p style="margin-left:40px;"><strong>As with the above, how can I increase or override the page limit, and how can I set the pagination to false (i.e just to a single worksheet) for format XLSX?</strong></p><p> </p><p> </p><p>Also, regarding the Export Formats that are displayed in the Export Content dialog box, is there a way to configure the Export Format options to:</p><ul class='bbcol decimal'><li>Show only particular Export formats which a particular report is designed for </li><li>Show a default Export format (e.g. Show Excel by default instead of PDF)?</li></ul><p> </p><p>Cheers,</p><p> </p><p>Richard</p>
Find more posts tagged with
Comments
richardcooper25
<p>I found the answer for configuring the export page limit:</p><p> </p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/devshare/_/designing-birt-reports/1411-limit-the-number-of-pages-that-can-exported'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/1411-limit-the-number-of-pages-that-can-exported</a></p>
;
mwilliams
Sorry for the delay. Glad you found a solution.
sschmidt.evalue
<p>You didn't answer how to turn single sheet on or off, which I'm desperately in need of.</p>
mwilliams
<p>Sorry. If the output is xls or xlsx, set the layout to auto layout. That should do it. If you have a table in your report, you'll probably also need the page break interval to be set to 0.</p><p> </p><p>You should be able to check the output format in the beforeFactory with:</p><p> </p><p>if (reportContext.getOutputFormat() == "xlsx"){</p><p> //change layout from fixed to auto</p><p>}</p>
Sai krishna
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Hi,</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">I have a report which contains 334 pages. </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">The report displays correctly in the viewer in the browser but when I am trying to 'Export Content' into .XLS a dialog box pops up with:<em>"This report exceeds the max export page count limit. Only the first 200 of pages are exported."</em></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">If I select 'Yes', the report exports to one Excel work sheet but with data missing.</p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Anyone of you could you help me out from this. Thanks in advance.</p>
richardcooper25
<p>Hi Sai,</p>
<p> </p>
<p>In web.xml of the birt view toolkit, you need to set the ALLOW_EXPORT_PAGE_LIMIT to 0</p>
<pre class="_prettyXprint _lang-xml">
<context-param>
<param-name>ALLOW_EXPORT_PAGE_LIMIT</param-name>
<param-value>0</param-value>
</context-param>
</pre>
<p>Cheers,</p>
<p>Richard</p>
Sai krishna
<p>Hi richard,</p>
<p> </p>
<p>I have tried that but i am unable to update it because i am getting a pop-up message as 'Access Denied'. Please help.</p>
<p> </p>
<p>Thanks,</p>
<p>Sai</p>
richardcooper25
<p>Hi Sai,</p>
<p> </p>
<p>Do you mean that you weren't able to update the web.xml of the birt view toolkit due to a permissions issue on that file?</p>
<p> </p>
<p>Cheers,</p>
<p> </p>
<p>Richard</p>
Sai krishna
<blockquote class="ipsBlockquote" data-author="richardcooper25" data-cid="146014" data-time="1479437073">
<div>
<p>Hi Sai,</p>
<p> </p>
<p>Do you mean that you weren't able to update the web.xml of the birt view toolkit due to a permissions issue on that file?</p>
<p> </p>
<p>Cheers,</p>
<p> </p>
<p>Richard</p>
</div>
</blockquote>
<p>Yes!!!</p>