Thursday, January 21, 2010

Tribix 2.5.1 released

I'm pleased to announce that Tribix 2.5.1 is released.

What's New:
==========

o Added customizable sheet name support for XLS output.
o Fixed totol page support(BIRT 2.5.1 or above).
o Updated POI dependency to 3.5 final.

Tribix update site is also available since this release:

http://tribix.sourceforge.net/update

11 Comments:

At February 17, 2010 4:37 AM, Blogger Kiran Vaidya said...

Hello,

I am using BIRT 2.5.1 with this Tribix 2.5.1 in my web application to generate XLS reports with data and charts and it is working fine.

Kindly tell me how to add customizable sheet name support for XLS output (with source code) and what are the other things of the XLS output i can customize?

Also how to configure fixed row height support for XLS?

Your help is extremely appreciated.

Thanks in advance,

Kiran

 
At February 17, 2010 4:53 AM, Blogger Kiran Vaidya said...

I am unable to set the sheet name and delete empty rows. I am using the code-
Map xlsConfig = new HashMap( );
// Check out constants in XlsEmitterConfig.java for more configuration detail.
xlsConfig.put("remove_empty_row",true);
xlsConfig.put("sheet_name","SheetXXXXXX");
xlsConfig.put( "fixed_column_width", new Integer( 50 ) ); //$NON-NLS-1$

// Associate the configuration with the XLS output format.
config.setEmitterConfiguration( "xls", xlsConfig );

However only the "fixed_column_width" is working fine :( :( .. plz help

 
At February 20, 2010 1:51 AM, Blogger Shawn said...

You can refer to http://sourceforge.net/apps/mediawiki/tribix/index.php?title=Examples_for_custom_sheet_name_expression for how to configure the custom sheet name.

Note "remove_empty_row" only removes rows that constians neither style info nor content.

 
At February 22, 2010 5:17 AM, Blogger Kiran Vaidya said...

Yeah! Thnx a lot.

However the cell width and height is creating a little bit of an issue with the tribix emitter when only tabular data is being displayed through BIRT crosstab.

I would be really really thankful if you just tell me the source code of accessing the generated Chart Image from Java code.

I would then take the image as a byteoutputstream and using apache poi display it in an excel file.

Plz plz email me the solution at kiran.vaidya@standardbank.co.za or kiran.vaidya@gmail.com

My working source code to generate a Birt report in excel is

---------------------------------
ByteArrayOutputStream reportOutput = new ByteArrayOutputStream();
IReportEngine birtReportEngine = BirtEngine.getBirtEngine();
IReportRunnable design = null;
String reportPath==getContext().getServletContext().getRealPath("/reports")+ "/reportchart.rptdesign";
design = birtReportEngine.openReportDesign(reportPath);

IRunAndRenderTask task = birtReportEngine.createRunAndRenderTask(design);



IRenderOption options = new RenderOption();
options.setOutputFormat(outputFormat);//outputFormat="xls","ppt","doc"
options.setOutputStream(reportOutput);
Map appContext = task.getAppContext();
appContext.put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY,
GenerateReportActionBean.class.getClassLoader());
task.setAppContext(appContext);
task.setRenderOption(options);
task.run();
task.close();
-----------------------------------

I can access the Chart object at runtime from the following code
-----------------------------------
ExtendedItemHandle eih = (ExtendedItemHandle) design.getDesignHandle().getDesignHandle().findElement("NewChart");
ChartWithAxes barChart = (ChartWithAxes) eih.getReportItem().getProperty(
"chart.instance");
-----------------------------------
plz tell me how to access the generated chart image (JPG or SVG)

 
At February 23, 2010 1:53 AM, Blogger Shawn said...

The image content is only accessible in the engine emitter interface. You cannot get it through model API.

 
At March 17, 2010 5:01 PM, Blogger OctaviusMaximus said...

Hi. I've been playing a lot with BIRT and found the Tribix Emitter looking for a way to export my resports as both PDF and XLS with tons of images.

I've found Tribix to do the job however I find the way it exports hidden (or 1 pixel long or wide) rows and columns making a mess that looks ok but if you navigate through it with the cursor, it becomes a hell...

Is there a way to make the rows and columns just as even as the original BIRT emitter?

 
At April 27, 2010 5:16 AM, Blogger Leonid said...

I'v faced the same problem as OctaviusMaximus. Shawn,is it possible to delete the hidden rows and columns?

 
At September 21, 2010 11:31 PM, Blogger Dharma said...

Hi,

I am using tribix 2.5.1 to generate XLS reports with data it works fine but i have one problem that it is generating a new worksheet for each page-break i don't need this then what i have to do?? please help me

i.e. i need whole report in a single sheet of excel as it is in html formats

if i will generate directly(with out using tribix) excel file contains only xml code

Thanks in advance

Dharma

 
At October 12, 2010 1:56 AM, Blogger Артем said...

2Dharma

config = new EngineConfig( );
config.setBIRTHome(...);
Platform.startup( config );
IReportEngineFactory factory = ...;
IReportEngine engine = ...;

...
xlsConfig.put( "export_single_page", true ); <--- here is the magic
config.setEmitterConfiguration( "xls", xlsConfig );

 
At March 28, 2011 9:03 AM, Blogger Colococolo said...

It's been a qhile since the last comment was made, but I can't find a solution anywhere.

Tribix XLS emitter creates a new worksheet for each filled "page". That is, if the page type is Letter, when the content(text, table, etc) reaches that size, it creates a new sheet and continues with the rest of the content.

I need tribix to create a new sheet with each page break and not with the page size.
I found this line in the the plugin.xlm:

pagination= "paper-size-pagination"/>

with blind faith I tried to change it to "no-pagination" or "page-break-pagination" but no luck.

Is there a way of forcing new sheets ONLY with page breaks and NOT with page size?.

I'm using the last version of tribix with Birt webviewer 2.6.2

Thank you in advance!

 
At May 23, 2011 3:55 PM, Blogger Rama Krishna said...

Did anybody have a fix for blank columns generated by Tribix?

http://www.birt-exchange.org/org/forum/index.php/topic/20667-export-to-xls-using-tribix-xls-emitter-error/page__s__654a6c5ef1de2b19e9a9608473d00c41

I think we should get rid of Tribix and move to BIRT's internal excel emitter.

 

Post a Comment

<< Home

Google