amadei

Hi. Im having some problem with a simple crosstab with two dataset column (referringDate e companyName) as row. This is what Crosstab wizard build as design. Im ok with it. Unfortunally, when exported to Excel, I got this. As you see, Referring Date row is not vertically merged. What I want and what I was expecting was this: I've tried some property combination but I cant reach this goal. Anyone can Help me? Thanks!

Hugo Mendoza's andwer guided me to solve the problem. I'm using Jaspersoft Studio. During Crosstab Wizard, when you select the field to put inside the cell, the default "aggregate function" is count. Changing the function during the wizard, rise a Null Pointer Exception so leave "count" as function. Now, edit the Crosstab and use "SUM" function for your measure. If you use "none" as function, the value will be printed correctly in the cell but TOTALS Cells doesn't work. So us SUM for your measure.

I have this simple data table: YEARCAUSAL NAMEMONTHVALUE2017FIRST11002017SECOND12002017FIRST21502017SECOND25002016FIRST14002016SECOND13002016THIRTH11202016FIRST21002016SECOND3400I'm creating a report with a group by year. I want a cross tab for every year. In cross tab's columns I need the available months. In cross tab's rows I need the causal name. Somethings like this: YEAR: 2017 CAUSAL NAMEGENFEBFIRST100150SECOND200500YEAR: 2016 CAUSAL NAMEGENFEBMARFIRST4001000SECOND3000400THIRTH12000I put crosstab in GroupFooter and I have set the reset value of dataset to Group. I down know why but I get value "1" in every cell of crosstab. I've tried the simplest version of report with one year and one month. Every causal has a value so no "empty" cell has to be managed. Please, help me! Thanks!