Export the report tab name as Excel sheet

<div>Hi All,</div>
<div> </div>
<div>We created the tabbed interactive tabbed report. It is exporting all tab's content in a single excel sheet only if we are trying to exporting xls. But, we want to one sheet by a tab with tab name as sheet name. We have tried with reportContext.setPageVariable( reportContext.PAGE_VAR_PAGE_LABEL, "customers" ) at each table onPageBreak with check the box 'Output to multiple sheets' option. But, No luck and it is exported as last onPageBreak event name as sheet.</div>
<div> </div>
<div>Please find the sample report in attachments and it is using the Classic Models sample database.</div>
<div> </div>
<div>Please help me how can I achieve this functionality.</div>
<div><strong>Environment</strong> :</div>
<div>
<div>Actuate BIRT Designer Professional </div>
<div>Version: 4.4.0</div>
<div>Build id: v20150206</div>
</div>
<div> </div>
<div>Thanks,</div>
<div>Srinivas</div>

Find more posts tagged with

Comments

Matthew L.

<p>Looking over the design I determined that the cause of the issue is that you have "Page Break Interval" set to '0' (See Image) for the table elements.</p>
<p>In the attached design, I set each table to "Always" break after the table.</p>
<p>This causes the Excel output formats to have multiple tabs and name them based on the "onPageBreak" code you are using.</p>
<p> </p>
<p>Hopefully this helps.</p>

Srinivas Yarra

<p>Hi Matthew,</p>
<p> </p>
<p>Thank you for your reply.</p>
<p> </p>
<p>This is working in exported to excel output. But, if we click on Employees or Orders or Payments tab then it is showing blank @ online report (i.e.Interactive way)</p>
<p> </p>
<p>Please find screen shot in the attachments.</p>
<p> </p>
<p>Thanks,</p>
<p>Srinivas</p>

Srinivas Yarra

<p>Hi,</p>
<p> </p>
<p>Is it possible to enable the each table pagebreak after property value is <strong>always</strong> only at time of exporting ?</p>
<p> </p>
<p> </p>
<p>Thanks,</p>
<p>Srinivas</p>

Matthew L.

<p>Unfortunately in the Professional version of BIRT the report tasks are "RunThenRender" which separates the "Run" and "Render" tasks.</p>
<p>This prevents knowing the output "Render" format during the report generations "Run" task ahead of time.</p>
<p> </p>
<p> </p>
<p>In the Open Source version of BIRT the report tasks are performed all as one task (eg. "RunAndRender") this allows the following JavaScript command to determine the output format ahead of time which would allow us to set the page break based on the output format.</p>
<pre class="_prettyXprint _lang-js">
var exportFormat = reportContext.getOutputFormat(); //Returns output format
</pre>
<p>An alternative solution could be to have duplicates of the tables (one with and one without page breaks) then use the viability rule to show/hide the tables based on the output type. Then one table (without breaks) could be used for the HTML tabs, and the other table (with breaks) would be used when exporting to Excel formats. While not a perfect solution, it might work as a workaround.</p>