JFreeReport 0.9 and export to excel support

[srilatha_a]

Hello,
I'm a new bie to JFreeReport.I found it to be very interesting and definitely we would love to use integrate it with in our application.

Here are the questions I have:-
My requirement is that I have a set of data all pruned and ready to be showed on the browser as an excel sheet.

I was hoping to use the PentahoReportDesigner to generate a basic report template and use JFreeReport 0.9(I want to use 0.9 since its latest and greatest) to show the data in Excel format.

Is this achievable with the current release of JFreeReport 0.9?
If it is achievable then can you provide me with some link/source code to do that.I did download the demo version jfreereport-demo-0.9.0-02 but did not find anything to export to excel.

Also I want to use export to excel in our Production.This basic functionality would help us a lot but would this release 0.9 be stable and recommened to use in Production env?

It would be great it I can do this. Since our current application is using POI and its painful even to rename a single column since we have to touch java classes.

Thanks,
Srilatha.

[Taqua]

Hi,

JFreeReport 0.9 is still in the active development - so it is buggy, slow and incomplete. While talking about incompeteness: The Excel-export is not yet added. It is still sitting on the todo list like so many other things.

If you want stable reporting, stick with the 0.8.x branch for now. JFreeReport 0.9 is definitly a couple of months away from being production ready. (More than six definitly, presumably more.)

JFreeReport 0.8.x is an parallel development branch that continues the old code line until JFreeReport 0.9 can be safely declared production ready. It is what's used in the plattform and supported by the design tools. It is safe to stick with that one. JFreeReport 0.9 is a complete new implementation of the engine - it has nothing in common with the old engine anymore (except the name and some third party libraries :)).

(And its also good to give us a detailed list of what you need in 0.9 - no matter how special or arcane the requirements may sound. If they are to far away from our abilities, we will tell you so - but every detail we know makes sure we head into the direction suitable for your use-cases.)

Have fun,
said Thomas

[pratipsen]

Sir,
I have developed a set of analytic reports in Pentaho 1.6 and deployed them on websphere 6.1.

Regarding export to excel - I am facing the following problems:

1. In the analytic report the values are shown prefixed with the '$' sign but when the same is being exported to excel the '$' does not exported.

Eg. the $100 in the online pentaho report when exported to excel shows up as 100


2. Suppose the value is 9.30 in a particular column in the pentaho report - then on exporting it to excel it shows as 9.3 - the zero goes missing.

I have done a lot of google but to no help.
Is there a way to make these formatting changes proper?