Dynamic columns

[erez.raveh]

Hi All,

My problem is that I want to present month and it's value dynamic way according to input,

for example:

for this input

1.From Date:2016-01-01

2.To Date:2016-03-01

i'd like to get 3 columns:

Jan           feb            mar

10            20              30

---

and for this input

1.From Date:2016-01-01

2.To Date:2016-05-01

i'd like to get 3 columns:

Jan           feb            mar              Apr              May

10            20              30                15                6

 

 

I manage to present static 3 month incolumn by set the "from date" as lower bound and increase months manually

can it be done dynamicly for 1-12 months?

 

Thanks,

Erez Raveh

[hozawa]

Are you using cross tabs? Cross tab component allows dynamic columns.

[erez.raveh]

didnt manage to work with the cross tab because it request 3 paramters 

1. column - the month

2.rows - ?

3. measures - my DocCount*

every option i've tried didnt present the required

*I'm using Jasper to present ElasticSearch results

[MiditecReportDev]

You could use a normal table with twelve columns and set one printWhen Expression to each column that only print the column when the month in question is in the given date range. Table column that are not printed do have a width of 0 so you won't have space issues either.

Not the best solution (I think) but it definitely is one ;)

[reportdev]

check this post for jrxml.

http://community.jaspersoft.com//questions/525633/removing-empty-space-between-columns