Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Excel output from BIRT
Excel output from BIRT [message #193930] Tue, 03 October 2006 14:34 Go to next message
Krishna Venkatraman is currently offline Krishna Venkatraman
Messages: 1476
Registered: July 2009
Senior Member
Hello,

I am interested in understanding how you would use the Excel output from
BIRT if BIRT had this feature today.


o How important is the formatting in the Excel output?

o Do you expect all tables in a report to be dumped out in Excel?

o How about multiple work sheets from the report?

o Do you expect to be doing a lot of calculations and other
traditional Excel like manipulations of data?

o Any other thoughts on the use case?

Thanks much!

Krishna
Re: Excel output from BIRT [message #193945 is a reply to message #193930] Tue, 03 October 2006 14:37 Go to previous messageGo to next message
Mauro R. Ubeda is currently offline Mauro R. Ubeda
Messages: 33
Registered: July 2009
Member
Hi, i will give my opnion too for this topic.

* How important is the formatting in the Excel output?

Very!!! Sales & Administration Department on my company use excel
very very often.

* Do you expect all tables in a report to be dumped out in Excel?

Yes.

* How about multiple work sheets from the report?

Mmm, i am not sure about it.

* Any other thoughts on the use case?

I am thinking on charts but is not a critical issue, because i can do it
on excel.

* Do you expect to be doing a lot of calculations and other traditional
Excel like manipulations of data?

Yes, data on Excel is easy to manipulate and customize.

Thanks,

Mauro Ubeda


Krishna Venkatraman wrote:
> Hello,
>
> I am interested in understanding how you would use the Excel output from
> BIRT if BIRT had this feature today.
>
>
> o How important is the formatting in the Excel output?
>
> o Do you expect all tables in a report to be dumped out in Excel?
>
> o How about multiple work sheets from the report?
>
> o Do you expect to be doing a lot of calculations and other
> traditional Excel like manipulations of data?
>
> o Any other thoughts on the use case?
>
> Thanks much!
>
> Krishna
Re: Excel output from BIRT [message #193953 is a reply to message #193930] Tue, 03 October 2006 15:39 Go to previous message
George Handin is currently offline George Handin
Messages: 109
Registered: July 2009
Senior Member
Krishna Venkatraman wrote:
> Hello,
>
> I am interested in understanding how you would use the Excel output from
> BIRT if BIRT had this feature today.
>
>
> o How important is the formatting in the Excel output?
>
> o Do you expect all tables in a report to be dumped out in Excel?
>
> o How about multiple work sheets from the report?
>
> o Do you expect to be doing a lot of calculations and other
> traditional Excel like manipulations of data?
>
> o Any other thoughts on the use case?
>
> Thanks much!
>
> Krishna

Currently, we are able to export table-only formatted data from BIRT to
excel by ctrl-A'ing the page and pasting it into Excel v2003.
Unfortunately, this does not work too well for reports with charts ...
or reports with multiple sections (separated by manual page breaks
within the report design).

As for the multiple worksheet option, my vote is to only put data onto
separate worksheets if the report design has a page-break specified. If
the data happens to span multiple pages in HTML format (and no page
break is forced by the report design), then it should all go into a
single worksheet in Excel.

As for data manipulation: We export the data as mentioned above into a
read-only worksheet and then have other Excel documents that manipulate
the "raw" data as needed.

It would be good if the Report Viewer would support this new format as
well. For example, "&__format=xls" and have the option to control some
common parameters via url parameters rather than programmatically having
to create an Excel emitter.

On a side note, I have been rather displeased with the usability and
performance of the Tribix project. It is *very* slow. The user
interface is not friendly. I stopped using it when the author rejected
my bug requesting the creation of an "all on one page" feature.
Hopefully, you Actuate developers can come up with something better.
Previous Topic:Excel Sheet Generation
Next Topic:Graphs in Web Viewer example app?
Goto Forum:
  


Current Time: Tue Jul 29 17:01:19 EDT 2014

Powered by FUDForum. Page generated in 0.01718 seconds