ReportServer Forum

remijouannet

Member

Registered: 2015-05-18

BIRT Excel, multiple sheet

Hi everyone,

I have a problem with Excel Export on BIRT reports,
when I try my reports with "BIRT report viewer" the page break result in making a new sheet in the excel export,
But when I try to do the same in reportserver, the excel doesn't have mutliple sheets, juste one long ugly sheet wih the columns a little bit messed up.

do you have a solution for that ? maybe a little groovy script to fix it ?

thanks in advance for your answer

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: BIRT Excel, multiple sheet

Hi,

this is somewhat related to http://forum.reportserver.net/viewtopic.php?pid=1413. In the current version we still use the old XLS emitter which does not support page breaks. In the new RS release (probably released within the month) we switch to the new emitter which takes care of this.

In the meantime, what you can do is to integrate the new emitter yourself. The script guide has some pointers to get you started on this.

Cheers
-Arno

remijouannet

Member

Registered: 2015-05-18

Re: BIRT Excel, multiple sheet

Ok thx, I'm gonna look at it

msmith

Member

From: Canada

Registered: 2015-01-25

Re: BIRT Excel, multiple sheet

Hi Arno,

Just curious - which BIRT emitter are you switching to? SpudSoft XLS? Spudsoft XLSX? Or another?

Thanks,
Mike

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: BIRT Excel, multiple sheet

Hi Mike,

Birt from version 4.3. on has integrated the Spudsoft XLSX emitter. We now also for Birt respect the setting in excelexport.cf, that is, if it is set to XLSX we tell Birt to to go for XLSX which in turn then uses the Spudsoft emitter.

Cheers
-Arno