How can I create dynamic column in iReport design

[muzzy2828]

Hi 

I have an criteria frame and I choose some criteras from this  screen, for example if I check a checkbox then I want to be add an extra column in ireport dynamically

[ajinkya_c]

Design your report with all columns and handle the hide/unhide using "Print When Expression" & parameter value.

But the position of the columns are static.

[oesina]

You can also pass your column name as report parameter, for example

displayColumn with a list of values. Then in your query you can make something like

select $P{displayColumn} as displayField from myTable

So that you have field in the report to create tables and charts with a constant name.

Good luck reporting!

[muzzy2828]

yes I tried it before but after remove column, next column's place didn't change. I need to shift remaning columns to left dynamic

[mithal.tirani]

Hello i'm trying to do that,select $P{ColumnsToDisplay} as displayField from myTable

it doesn't work:(