How to force column headers to not repeat in 4 column report

[dprogrammer]

Hello everyone, Is it possible to force column headings to show only once for first row on each page? I have a column styled report and I am showing 4 rows in vertical format and column headings are repeating for all four rows hence creating space problems. 

Currennt sample out put:

Page 1

FirsName:    John Smith       First Name: Ebony Clyde       First Name: Ekin Johove      First Name: Dolat Ram

Dept:            HR                   Dept:            HR                      Dept:            FIN                  Dept:            IT

Salary:         40000              Salary:         38000                   Salary:         50000               Salary:         20000

DESIRED OUTPUT:

Page 1

FirsName:    John Smith     Ebony Clyde     Ekin Johove    Dolat Ram

Dept:            HR                  HR                    FIN                  IT

Salary:         40000              38000               50000               20000

 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Anuja Vilas Bhujbal]

Hello, 

 

Can you please share your report design to help us better understand it?

[dprogrammer]

Uploaded files. Hope this helps you understand my question. I changed data from my sample to different dataset but the layout is same. 

[olyncircle]

You can use PRINT WHEN EXPRESSION using the variable COLUMN_NUMBER.

Put this on the Static Text / Label

$V{COLUMN_NUMBER} == 1[/code]

This means that the label will only show on the first column.

[dprogrammer]

Thank you Olyncircle! That worked.

I alwys thought column_number variable would store how many columns (fields) we have on the report. But looks like column count tells how many columns we are displaying vertically for each distinct row, which in my case was 4.