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

Home » Archived » 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

Eclipse User

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 836 times)
Attachment: screenshot.png
(Size: 42.91KB, Downloaded 750 times)
Attachment: cl_stock.rptdesign
(Size: 523.38KB, Downloaded 1109 times)

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

Wed, 14 March 2012 17:42

Eclipse User

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
>
>

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

Fri, 16 March 2012 09:12

Eclipse User

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

Eclipse User

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.

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

Tue, 17 July 2012 07:00

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 08:39:36 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter