Excel Export - Merge cells -

[sadakar]

Design of the report : 

Expected output AND Jasper Design Studio ouput when selecting(check box is ticked Cell properties of Excel export) 

Problem :

Current output when viewing the reort output in server

Could anybody solved this issure previously ? 

My trails are : 

http://community.jaspersoft.com/wiki/excel-export-settings

http://jasperreports.sourceforge.net/sample.reference/xlsfeatures/index.html#xlsfeatures

Added " <property name="net.sf.jasperreports.export.xls.row.outline.level.1" value="End"/>" to all the cells in that are placed in group by band and to the cells(Text fields) in Details band. 

No luck ..!! 

Did anyone face the same issue & if you had fixed this please share your inputs.

Help would be appricated much 

Thanks, 

Sadakar Pochampalli

[carlos2015]

See this:

http://community.jaspersoft.com/wiki/xls-export-parameters-jasperreports-server

You should put this property "removeEmptySpaceBetweenRows" in true

[sadakar]

Hi Carlos, 

Thank you for your inputs, I tried with the property that you have suggested and with the combination of others from the link. None of them worked for me. 

the output is coming as expcted in Studio but no in server export. 

[grouchysmurf]

I realize this is an old question, but I recently dealt with the same issue.  After too many hours of frustration, I found a solution.  The OP's report requires cells to merge across rows. Jasper prohibits this by default.  Try this:

<property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>

The default for this value is true.  Set it false and voila!

[djohnson53]

grouchysmurf,

Thanks for taking the time. These QnA's, after they might've helped one person, can be pruned and edited to make them more valuable to others. So, answering an old question, if you are adding or updating knowledge, is great.  

What versions of JSS. iReport, JRL, etc. did you use?  Just for the record.

[bikumars]

Can you please let me know if anyone have answer for it, i am still facing issue while export and also tried every properties from community.

My excel export from Crosstab still not merging row groups.