BIRT Report Header/Footer in XLS

Hello together,

I?m using the "BIRT Report Designer" v. 3.7.2 for a lot of reports by now. Today I tried using the header/footer function in BIRT for a report generated in xls-format (Office 2010). I expected a header/footer for every generated Page, just like in the pdf export, but the standard-emitter gives me just one line at the beginning and at the and.

My question: Is there an attitude, that can be used in BIRT for using the "header/footer function" (see image attached) in excel?
Or do I need another Emitter for that???

Find more posts tagged with

Comments

mwilliams

My guess is that this is a limitation/feature of the Excel emitter. You could try the Native XLS emitter or the SpudSoft XLS emitter, to see if they handle this.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

http://www.birt-exchange.com/be/marketplace/app-showcase/?app=102

Yaytay

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108622" data-time="1345228342" data-date="17 August 2012 - 11:32 AM">
My guess is that this is a limitation/feature of the Excel emitter. You could try the Native XLS emitter or the SpudSoft XLS emitter, to see if they handle this. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/</a> 
 
<a class='bbc_url' href='http://www.birt-exchange.com/be/marketplace/app-showcase/?app=102'>http://www.birt-exchange.com/be/marketplace/app-showcase/?app=102</a> </blockquote>
The SpudSoft emitter, by default, does what you want, but note that the header/footer have very limited formatting in Excel and whatever you provide will be coerced into the right format. 
Also, the Excel header/footer has three sections, so for the most control put you header/footer into a three column grid. 
 
I suspect that SpudSoft is the only emitter that does this (because it is a low fidelity representation), if others do allow you to control the Excel headers/footers they would probably do it via a custom method. 
 
The SpudSoft emitter has an option to turn off the use of native headers/footers, which is needed if you want graphical output n them. 
 
Jim