In using the KNIME BIRT Reporting tool, and using a Table to display the results, is there any way to force a Page Break in the table when a certain property changes value.
For example, you may be listing a series of molecules in a table, which are split into 3 classes; "Platform A", "Platform B", and "Platform C". Is it possible that as the compounds are being listed on each row in the table, that once the compounds change from "Platform A" to "Platform "B", a page break is introduced, and likewise the same is happens when going from "B" to "C".
I know its possible to set up separate tables for each A, B, and C. But the dataset could change to have any number of compound platforms so this is not really a possible solution.
Try right-clicking on your table and doing 'Insert Group' - group by whatever field your classes are in, set page breaking options, and then use the group data row in the table for the actual table layout, I think will do what you want (you may or may not want to keep the group header/footer rows too)
What a star!
I didnt think this was going to be possible. That is absolutely perfect, exactly what I wanted to do.
Thank you very much.
I have similar situation, but I'm not able to get those groups headers displayed once for a group. I would like to get something like (following Simon's example):
What I get is:
Any help would be appreciated.
Can you do the data preparation in KNIME before passing the prepared data to the BIRT reporting in KNIME?