How to print dynamic field in to report using sql

[kchavda]

I wan to print dynamic field into my report.

Like From my query i got result

Name

a

b

c

now i want to display this value as a field like:

a                      b                        c

[hozawa]

You can use "columns"

[jo.jasmine]

How many values/rows that your field have?

for your example, this is what I do.

I will drag the field/column thrice into detail band. for the first column, I use print when expression and write

$V{REPORT_COUNT}==1

which means that the first row is displayed. Similarly, I will do for the other two columns.

If your field has more than 5 values then you need to consider for another choice.

 

Let me know how it worked for you