nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change of layout in beforeRender event

dzish

Hi,
 
I have upgraded BIRT from 4.2.2 to 4.5 and have problem with Excel export.
 
When I have many rows new sheet is made. I read I had to change layout from "fixed" to "auto". When I change this layout in designer it looks fine but when I try to change layout programatically in beforeRender event it does not work. I added example report with text items of export type and layout preferences. They have right value after event but report looks like with fixed layout, in xls and even in html (in html 3 pages, in xls 3 sheets).
 
Can you help me how to force BIRT for real change of layout?

Find more posts tagged with

Comments

sureshpulapalli

Please attach sample report if you have any.
 
It depends, how you are running and exporting the report output.
 
Put the script in initialize method, If you are executing the report in viewer and then exporting the report into excel.
 
 
 
Regards,
Suresh

dzish

Oh, sorry. I attached one file but there are two steps for attaching. there is table and report.onRender event skript

Matthew L.

Per your example, I modified the existing code and moved it into the onPrepare method of the report.
This method works for the OpenSource version of BIRT only (will not work in BIRT Pro).
Hopefully this modification works for you.
 
Modified Code in onPrepare:
<pre class="_prettyXprint _lang-js">
var outputFormat = reportContext.getHttpServletRequest().getAttribute("attributeBean").format;
if("xls,xlsx,html".indexOf(outputFormat) > -1){
reportContext.getDesignHandle().layoutPreference = "auto layout";
}
</pre>

dzish

<blockquote class="ipsBlockquote" data-author="Matthew L." data-cid="144361" data-time="1466516470">
<div>
 
Per your example, I modified the existing code and moved it into the onPrepare method of the report.
This method works for the OpenSource version of BIRT only (will not work in BIRT Pro).
Hopefully this modification works for you.
 
Modified Code in onPrepare:
<pre class="_prettyXprint _lang-js">
var outputFormat = reportContext.getHttpServletRequest().getAttribute("attributeBean").format;
if("xls,xlsx,html".indexOf(outputFormat) > -1){
reportContext.getDesignHandle().layoutPreference = "auto layout";
}
</pre>
</div>
</blockquote>
Yes, it works! Thank you. I haven't thought about that event - onPrepare.