Setting Excel Print-Preview/Page-Setup parameters in BIRT

Hi,

I use birt to create reports which are mostly exported to excel. The reports are exported fine, but the page setup in excel is not set properly.

Is there anyway to set excel page-setup/print-preview in birt?

Thanks.

Find more posts tagged with

Comments

mwilliams

What do you mean the page is not set properly? Can you explain a little more in detail? Also, I'm guessing you're using BIRT, not BIRT spreadsheet, so I'm going to move this post to the designing BIRT reports forum unless you tell me otherwise.

hkvd

Hi Michael,

Thanks for the quick reply.

You're correct. I'm using BIRT (not BIRT spreadsheet). Sorry for posting in the wrong forum.

After the BIRT report is exported as an excel file (xls), when it is printed, the print preview does not show up properly and needs to be setup manually every time before printing. For e.g. even though the layout of the master page of the BIRT report is set to landscape, it is not reflected in excel's print preview - where the layout of the sheet appears as potrait.

Another example would be a BIRT report with many columns. All the columns display perfectly fine when the report is exported as an xls file and viewed in excel. But when such a report is printed from excel, all the columns do not appear in a single page in the printout. To make all the columns appear/print in a single page, the scaling (% zoom) and orientation (potrait or landscape) needs to be manually set in excel's Print Preview -> Page Setup window.

I'd like to know if there is any way by which the BIRT report can be configured so that when it is exported as an excel file and printed, the layout, scaling and other dimensions are preserved ?

mwilliams

What is your BIRT version? I'll have to take a look.

hkvd

I'm using - Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build <2.2.2.v20080227-1131> 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73982" data-time="1298665798" data-date="25 February 2011 - 01:29 PM">
What is your BIRT version? I'll have to take a look. </blockquote>

hkvd

Hey Michael,

I think I can add the page-setup functionality be making a few modifications in the source code of the default BIRT xls emitter. I downloaded the BIRT source code and imported it in eclipse. However, I'm unable to build/compile any of the plugin projects since I'm getting many errors (mainly due to missing libraries - com.ibm.* and org.mozilla.javascript.* ). I tried adding the com.ibm.icu_version.jar and js.jar files to some of the projects but errors still show up.

Can you help me with this? Can you provide reference to any resource which has details about importing and setting up the BIRT source code/projects in eclipse so that I can modify the default xls emitter?

Otherwise, is there any other way to modify the xls emitter source?

Thanks again.