Making columns appear/disappear based on query (jaspersoft ireport designer 5.6.0)

[rawadbaz]

I have two tables in my database, in which i'm getting from one 2 (A,B) fields and from the other 6 fields (C,D,E,F,G,H).

What i want is that based on a parameter inserted by the user either a report (A,B,C,D,E) will appear or (A,B,F,G,H).
So two fields from the first table are constant and will appear, however based on the user input parameter, either C,D,E will appear with A,B. Or F,G,H.

Any idea on what method should i follow please?
 

[hozawa]

I don't think that could be done with iReport and iReport development has already ended so there's little chance that it'll get supported.

You'll probably have to create a program yourself that uses JasperReports library to create you report. You can filter datasource depending on the parameter.

 

[edu-de]

Why don't you just select all your needed fields in the query (select A,B,C,D,E,F,G,H) , and, depending on the parameters given, let some fields be shown or hidden? You can use "printWhenExpression" for this, e.g. for the field C: printWhenExpression= $P{showC}.equals("true"). So the user will only see the field "C" when the parameter "showC" is "true".

In this way you can show only the requested fields.