How to conditionally arrange row data to Multiple columns without row spacing.

[jisygeorge94]

We arrange row data in different columns using condition(using print when expression) within simple jasper design(didn't use nested reports). but we get the reserved space between rows in individual columns.

The result(Image) is added below.

Example wise description :- Label 1  1300.000 (Refer below image)is the first row data of result set. Then label 4   (17.330) is the second row data of result set. which is conditionally arranged in two columns (Column2 , column3).Actually we need the second row data(Label 4   (17.330)) in first row of column 3.Column 3 reserve space for first row of result set. How to resolve the issue?

 

We need result without spacing between row in individual colums. The expected  result is added below.

[yama818]

I don't think I can fully meet your requirements, but the first idea I came up with is a way to arrange the List components.

- Preview image

- Layout design image


- List component properties

- Parameter setting image

 

- Dataset SQL image

select * from t1 where prod = $P{P_prod}

 

I think it can also be achieved by using Table component or arranging sub-reports.

I hope this is helpful.