How to show column at Crosstab even the data is absent
<p>Do anyone have hints, if I want to create crosstab columns from array, then insert the correction information into the crosstab?</p>

<p>For example, I have a table like below in my DB:</p>

<h2>customer     ---- activity_date   ---- activity|</h2>

<p>customer1    ---- 01-01-2016     ---- A|</p>

<p>customer1    ---- 01-03-2016     ---- B|</p>

<p>customer2    ---- 01-01-2016     ---- A|</p>

<p>When users request report from JAN 16 to MAR 16, the report should be shown like below:</p>

<h2>customer    ---- 01-2016           ---- 02-2016           ---- 03-2016          |</h2>

<p>customer1   ---- Activity count: 1 ---- Activity count:0  ---- Activity count:1</p>

<p>customer2   ---- Activity count:1  ---- Activity count:0  ---- Activity count:0</p>

<p>total       ---- Activity sum:2    ---- Activity sum:0    ---- Activity count:1</p>

<p>The current problem is that, as there is no data within Feb 2016, the column 02-2016 is missing in the report.</p>

<p>Is there any way (like scriptlet) to create an array as column, then tell the JasperReport the insert correct data when activity_date == column_date?</p>

<p>I'm using Jaspersoft Studio.</p>