Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt report export to excel error(Birt report export to excel error)
Birt report export to excel error [message #820766] Wed, 14 March 2012 10:45 Go to next message
rahul rahuldeshpande89@gmail.com is currently offline rahul rahuldeshpande89@gmail.com
Messages: 16
Registered: February 2012
Junior Member
Hi ,
whenever i am trying export my tabular report to excel its giving error in
excel sheet (attached below).
Also graphical charts are not reflecting in excel sheet.

I tried tribix excel emitter but it is not keeping source report format in output excel sheet.
please suggest solution for this . I am using birt runtime 3.7 and apache tomcat server for deployment.
i am also attaching my report and its screen shot. i am calling report using Birt viewer.

Rahul

Re: Birt report export to excel error [message #821042 is a reply to message #820766] Wed, 14 March 2012 17:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you change all the elements that contain script tags to not export
to xls? Use the visibility expression in the property editor for this.
BTW charts and images are not exported to the default xls emitter.
You may want to try this one:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

Jason


On 3/14/2012 10:45 AM, rahul rahuldeshpande89@gmail.com wrote:
> Hi ,
> whenever i am trying export my tabular report to excel its giving error in
> excel sheet (attached below).
> Also graphical charts are not reflecting in excel sheet.
>
> I tried tribix excel emitter but it is not keeping source report format in output excel sheet.
> please suggest solution for this . I am using birt runtime 3.7 and apache tomcat server for deployment.
> i am also attaching my report and its screen shot. i am calling report using Birt viewer.
>
> Rahul
>
>


Jason Weathersby

BIRT Exchange
Re: Birt report export to excel error [message #822317 is a reply to message #821042] Fri, 16 March 2012 09:12 Go to previous messageGo to next message
rahul rahuldeshpande89@gmail.com is currently offline rahul rahuldeshpande89@gmail.com
Messages: 16
Registered: February 2012
Junior Member
Jason i set all javascript content as 'Allow export : false'
still i am facing same error in export(excel).
can you please explain me the procedure for deployment of native xls emitter inside apache tomcat ?


Rahul.
Re: Birt report export to excel error [message #824376 is a reply to message #822317] Mon, 19 March 2012 11:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Does the exported xls file have the drop downs in it? BTW replacing the
emitter should similar to using the tribix emitter. Look at the
following post:
http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html
Specifically look at specifying the emitter in the url.

Jason

On 3/16/2012 9:12 AM, rahul rahuldeshpande89@xxxxxxxx wrote:
> Jason i set all javascript content as 'Allow export : false'
> still i am facing same error in export(excel).
> can you please explain me the procedure for deployment of native xls
> emitter inside apache tomcat ?
>
>
> Rahul.


Jason Weathersby

BIRT Exchange
Re: Birt report export to excel error [message #896125 is a reply to message #824376] Tue, 17 July 2012 07:00 Go to previous message
Peter Lux is currently offline Peter Lux
Messages: 1
Registered: July 2012
Junior Member
I got the same problem and the solution was this:

Remove all
<property name="width">19mm</property>
tags which limits the size on "millimeter". Then it works!

(BIRT Framework 3.7.1)
Previous Topic:Birt rcp report designer 4.2.0 does not lauch
Next Topic:Extending the BIRT viewer?
Goto Forum:
  


Current Time: Fri Apr 18 16:59:13 EDT 2014

Powered by FUDForum. Page generated in 0.11373 seconds