Home > Forum > Known bugs > Multiplying rows in the report even when no columns from the item list chosen

Multiplying rows in the report even when no columns from the item list chosen

06.12.2023

10:17

Hi guys, got case here where in Webcon's report there is a row from item list. This row is added as a column to the [Columns available in report] as on the screenshot, but remains unticked, therefore not visible in the default view on the report. Nonetheless, report still shows multiple lines with same data/instance ID, if there is > 1 item list row with data on the form. This should be the case if the column is used in the report - ticked either in the default view or in one of the custom views. Whenever it is unticked, I believe report should not multiply rows. Do you experience same behavior in older versions?

Webcon ver. 2023.1.2.68

06.12.2023

11:10

Hi Patryk,
I think underneath adding that column to the data source it creates SQL join with list items on the whole data source.

If the join happens first, then you can hide the columns, but rows are already multiplied.
The solution would be to have two different reports.

I can confirm that behavior on 2023.1.2.123.