Eclipse Community Forums: BIRT » Birt report export to excel error

Help

Home

Home » Eclipse Projects » BIRT » Birt report export to excel error(Birt report export to excel error)

Show: Today's Messages :: Show Polls :: Message Navigator

Birt report export to excel error [message #820766]

Wed, 14 March 2012 10:45

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

Attachment: cl_stock-2.xls
(Size: 13.03KB, Downloaded 157 times)
Attachment: screenshot.png
(Size: 42.91KB, Downloaded 160 times)
Attachment: cl_stock.rptdesign
(Size: 523.38KB, Downloaded 96 times)

Report message to a moderator

Re: Birt report export to excel error [message #821042 is a reply to message #820766]

Wed, 14 March 2012 17:42

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

Report message to a moderator

Re: Birt report export to excel error [message #822317 is a reply to message #821042]

Fri, 16 March 2012 09:12

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.

Report message to a moderator

Re: Birt report export to excel error [message #824376 is a reply to message #822317]

Mon, 19 March 2012 11:54

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

Report message to a moderator

Re: Birt report export to excel error [message #896125 is a reply to message #824376]

Tue, 17 July 2012 07:00

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)

Report message to a moderator

Previous Topic:	Birt rcp report designer 4.2.0 does not lauch
Next Topic:	Extending the BIRT viewer?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 19:08:43 EDT 2013