• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

BIRT Reporting Tool. Getting the TEXT File

 
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Team,

I need a reporting tool for a project.
I have worked on Jasper, but never used BIRT. This project involves reports with massive data.

So which reporting tool is better in this case?

Also is there any way to generate report in TXT format using BIRT?

Request you to provide some light on these two points
 
Gagan Tiwari
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All
Please provide some thoughts on the same.

Other option which I can think of using the BIRT to gernerate either the HTML or the PDF and then converting the same into TEXT format.
Are there any open source or some conversion mechanism avaliable?
 
author
Posts: 3285
13
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'd prototype with both of them, a quick 2-3 day investigation with each technology should have you leaning one way or the other.
 
Gagan Tiwari
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Many thnaks for the reply

Just wanted to know, is there any API/tools which is available?
 
Gagan Tiwari
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All

I am planning to use the BIRT as the reporting tool, but the only constraint being that the BIRT dosen't give TXT format. So I am trying to acheive the same. For that I tried getting the EXCEL format and trying to parse the EXCEL and creating the TEXT file.
I have tried two options
1. Apache POI
2. JXL

The parsing code is working fine with an EXCEL file but when I run the code on the EXCEL generated from BIRT I am getting errors as follows

JXL API


jxl.read.biff.BiffException: Unable to recognize OLE stream
at jxl.read.biff.CompoundFile.<init>(CompoundFile.java:116)
at jxl.read.biff.File.<init>(File.java:127)
at jxl.Workbook.getWorkbook(Workbook.java:221)
at jxl.Workbook.getWorkbook(Workbook.java:198)
at JXMExcelToText.read(JXMExcelToText.java:16)
at BIRTReportBuilder.executeExcelReport(BIRTReportBuilder.java:178)
at BIRTReportBuilder.main(BIRTReportBuilder.java:396)


Using POI

java.io.IOException: Invalid header signature; read 7311066695147732796, expected -2226271756974174256
at org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:100)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:84)
at POIExcelToText.ExcelToText(POIExcelToText.java:24)
at BIRTReportBuilder.executeExcelReport(BIRTReportBuilder.java:171)
at BIRTReportBuilder.main(BIRTReportBuilder.java:389)

Kindly let me know how to proceed on the same. Also if there is any other way of gettting the TEXT file from BIRT.

BIRT VERSION:: 2.5
POI Version: poi.3.0.1FINAL
JXL Version: jxl2.6.10

BIRT Code for Excel Exporting::
EXCELRenderOption excelOptions = new EXCELRenderOption();
excelOptions.setOutputFormat("xls");
excelOptions.setOutputFileName("/QuantumFX/QFXREPORTS/BIRTSAMPLE/birt/output/Contract.xls");
task.setRenderOption(excelOptions);
 
Rancher
Posts: 1337
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
For starters: Is it a valid XLS file - can both Excel and OpenOffice open it without problem?

As to POI: version 3.0 is ancient; switch to the latest released version instead - it has hundreds of bug fixes.
reply
    Bookmark Topic Watch Topic
  • New Topic