Export parameters from JasperServer

[scottmacpherson]

I'm having problems with leading zeros being excluded from reports which are exported to Excel, and having read all the threads in this forum on the subject I know I should consider fidding with the IS_DETECT_CELL_TYPE parameter.

Problem is, I don't know where to set this parameter.

I'm creating reports using iReport, and then placing them on a JasperServer server, which is then accessed by users using a web browser.

It sounds like I need to change the export parameter on the JasperServer side of things, and not in the actual report JRXML. If I'm correct, can someone point me in the right direction?

Many thanks.

[szaharia]

Hi,

 

In a couple of days we'll make available the JasperServer 2.0 open source release. Your problem will be solved when you will download this version. Until then, keep in mind that the only thing you have to do to set your IS_DETECT_CELL_TYPE parameter is to modify as you wish, in the viewReportBeans.xml file, the "detectCellType"'s property value of the "xlsExportParameters" bean.

 

sanda