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

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

 

dprogrammer's picture
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 3 days ago

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.

arai_4 - 4 months 3 weeks ago

Hello, 

 

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

abhujbal - 4 months 2 weeks ago

3 Answers:

You can use PRINT WHEN EXPRESSION using the variable COLUMN_NUMBER.

Put this on the Static Text / Label

$V{COLUMN_NUMBER} == 1

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

olyncircle's picture
Joined: May 30 2022 - 5:42pm
Last seen: 3 months 1 day ago

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

Attachments: 
AttachmentSize
Binary Data multi_column_report.jrxml4.77 KB
PDF icon multi_column_report.pdf4.58 KB
dprogrammer's picture
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 3 days ago

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. 

dprogrammer's picture
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 3 days ago
Feedback