BIRT | Report Issues Upload

[PaoloG]

Hi,

when I create a new column in the input db to the report all aggregations change to normal columns.

Do you know why ?

[ScottF]

Hi @PaoloG and welcome to the forum.

I don’t understand the question since you haven’t provided much detail. Can you please upload your workflow and some screenshots to show what you’ve tried so far? This might be helpful too:

How to Best Ask For Help on the Forum

How to Best Ask for Help Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: How can you write a post that is most likely to get the help you need? You might think that logically, a good title for your post would be “Help with an error”, right? Well… not exactly. Put yourself …

[PaoloG]

Hi Scott, thank you

When I update the input dataset to the report with a column and do the report update.
The aggregated table variables in the report are transformed.

After updating the dataset (third image) if I press the back key I restore the aggregations and see the new column in the dataset.
But that doesn’t sound like standard procedure.

[ScottF]

It would really help if you could upload your actual workflow (with some dummy data) in addition to screenshots.

Having said that, the best approach might be to create the report format in BIRT after finalizing your table structure on the KNIME side, with all the columns you plan to include. I try to avoid updating the underlying data if I can, since that can cause unexpected behavior from BIRT, as you are seeing.