freeze pane in excel report using BIRT

Hi,

I am generating excel report using BIRT open source. I have to freeze header row in excel report. How can i do this using BIRT.

Thanks in advance,
Ashish

Find more posts tagged with

Comments

mwilliams

I'm not certain, but you might be able to do this with Actuate's BIRT Spreadsheet, but I don't think you can do this with the current XLS emitters available for OS BIRT. I could be wrong though.

Yaytay

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="99213" data-time="1334701279" data-date="17 April 2012 - 03:21 PM">
I'm not certain, but you might be able to do this with Actuate's BIRT Spreadsheet, but I don't think you can do this with the current XLS emitters available for OS BIRT. I could be wrong though. </blockquote>
 
You can't do it in the SpudSoft emitter, but I wouldn't mind adding it. 
I'm a bit busy at the moment, but if you file a bug at <a class='bbc_url' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/issues?status=new&status=open'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/issues?status=new&status=open</a> I'll get around to it soon. 
 
I think the way I'd handle it is to look for a UserProperty (or RenderOption) when rendering each cell - if the UserProperty exists and is true I'll use that cell as the frozen pane origin. 
That enables you to either set the property on a specific cell, or to use a script to change the RenderOption at the right time. 
Also, I'll only take the first one seen, so you can set it on every content row in a Table and it'll do what you expect. 
 
Jim

Yaytay

It's in v0.8.0 of the SpudSoft emitters.

The option ExcelEmitter.FreezePanes is checked when outputting cell contents - the first time that value is found to be true that cell is used as the point for the frozen panes (i.e. all cells above and to the left of that cell will be frozen).
As with all options on the SpudSoft emitters, the option can be either a UserProperty (on the cell contents or on any object containing it) or a RenderOption.

Enjoy.

Jim

Ankur_13

Attachment is the sample report Design in Which Header Locking Issue is Fixed for Excel

Freeze Header (2).rptdesign