Birt dynamic number of columns

Hello,
i have table in knime, sometimes it has 5 columns , sometimes 7 columns, and every time i want to create report i have errors. Is there any way to create dynamic table, so i don’t need to change number of columns inside birt report ??

Hi @k0sa

really sorry for the late reply.
This is a little bit tricky, as this needs two steps.

  1. Unpivot your data into a single column with the /Unpivot node
  2. in BIRT you need to create a CrossTable generate the width based on the ColumnNames.

I made a very small example here:

Hope this helps! Iris

2 Likes