Home
Analytics
Not able to get Excel Report
ravishanku
Hey Everyone,<br />
<br />
I have designed a report but the datas are not shown when i export into excel sheet.<br />
It <strong class='bbc'>works really fine</strong> when i export it into pdf format...<br />
<br />
A new message box appears while the excel sheet opens(attached below) ...don know what to do in that...<br />
the excel sheet screenshot i have got after clicking ok in the message box is also attached<br />
pls help...
Find more posts tagged with
Comments
mwilliams
So, exporting to open office displays the xls xml rather than the report? What is your birt and open office versions?
ravishanku
Eclipse BIRT Designer Version 2.6.2.r262_v20110209
Open office 1:3.2.0-7ubuntu4.2
ravishanku
me tried dis in excel sheet in windows....some datas are coming...images are not coming...and some calculations here and there are also missing
Expecting replies
Megha Nidhi Dahal
<blockquote class='ipsBlockquote' data-author="'ravishanku'" data-cid="77351" data-time="1306007076" data-date="21 May 2011 - 12:44 PM"><p>
me tried dis in excel sheet in windows....some datas are coming...images are not coming...and some calculations here and there are also missing<br />
<br />
Expecting replies<br /></p></blockquote>
Hi ravishanku,<br />
<br />
BIRT writes xls files as xml. In the latest of openoffice also, I had problems opening the generated xls. You need to have Microsoft office excel, atleast the reader to open the document and to be very sure.<br />
<br />
Regarding some data coming and some not, it happens with xls. pdf output is not exactly mapped with xls, to achieve a near about resemblance, you need to tweak the designer such that all columns are displayed. There is no straight forward answer on what is to be done, but by trial and error, the expected result can be obtained.<br />
<br />
Regarding images not exported, existing BIRT xls emitter does not support exporting images and charts, you can always request an enhancement at the eclipse bugzilla. I would suggest you to try out tribix emitters for exporting images.<br />
<br />
Hope this clarifies.<br />
<br />
Arpan
ravishanku
Thank you sooo much Arpan for your informative reply...!!!!
But one doubt; is tribix emitter a plugin of eclipse or where can i find it...??
Megha Nidhi Dahal
<blockquote class='ipsBlockquote' data-author="'ravishanku'" data-cid="77355" data-time="1306124694" data-date="22 May 2011 - 09:24 PM"><p>
Thank you sooo much Arpan for your informative reply...!!!!<br />
But one doubt; is tribix emitter a plugin of eclipse or where can i find it...??<br /></p></blockquote>
Tribix is also an open source project. Its hosted on <a class='bbc_url' href='
http://tribix.sourceforge.net/'>sourceforgenet.com</a>
. You can add it as a plugin to eclipse.<br />
The only thing that concerns me about tribix is, its a very old emitter, though very capable. No recent release has happened. You can probably try it out and post some feedback about it.<br />
<br />
Arpan
kallem
As Birt generates the Excel file in xml format it would be best if extension is .xml. At least we did encounter Excel showing an popup informing that file is of different format what the extension suggest. After a while that gets annoying and if you don't know the meaning or reason it makes you wonder what is going on.
We also run into problems while generated reports by email. With some Outlook Web Access clients when opening the file it is empty. This depends on email server configuration.
mwilliams
BIRT 3.7.0 has added emitters for Open Document Spreadsheet, Text, and Presentation.
ravishanku
For knowing how to implement Excel print in OpenOffice.org .. go to the thread link given below ..!!!!<br />
<br />
<a class='bbc_url' href='
http://www.birt-exchange.org/org/forum/index.php/topic/22613-opening-excel-report-in-openoffice-org/page__p__78675__fromsearch__1&#entry78675'>Open
Office Report in Birt</a>
