• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

BIRT Reporting Tool. Getting the TEXT File

 
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
  • 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
  • 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: 3281
8
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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
  • 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.
 
Put the moon back where you found it! We need it for tides and poetry and stuff. Like this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!