How to force column headers to not repeat in 4 column report
Posted on May 10, 2023 at 9:35pm
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
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 3 days ago
Posted on May 12, 2023 at 12:52am
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.
Joined: May 30 2022 - 5:42pm
Last seen: 3 months 1 day ago
Posted on May 11, 2023 at 12:29pm
Uploaded files. Hope this helps you understand my question. I changed data from my sample to different dataset but the layout is same.
Joined: Jul 19 2006 - 7:37am
Last seen: 2 months 3 days ago
Posted on May 14, 2023 at 11:16pm
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.
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.
Hello,
Can you please share your report design to help us better understand it?