Generate Multi page PDF Report using data from each row of an Excel file

#1

Hi all,

As a test, I currently am using an Excel datafile with 10 rows and 5 columns. I have generated a template report in Knime. On the report I used the “Table” item to add the specific column of data in the designated area of the report template. I would like to use each row of data to generate a single page which in turn becomes a multiple page PDF based on how many rows are in the datafile. The issue I am having is that it is printing data from all 10 rows on one PDF page, I need it to be 10 separate pages. I am trying to create invoices to different customers, essentially trying to mimic mail merge in Word.

Thank you

Jennifer

0 Likes

#2

Hi and welcome to the community @Jenspade,

Go to “Properties” tab of the table then “Page Break” section and set the value of “Page Break Interval” to one.

:blush:

2 Likes

#3

Unfortunately the last two options you list do not show up on my screen, see picture attached

Jennifer

0 Likes

#4

You have selected Data item not the Table.

0 Likes

#5

Okay that sort of helped, my new issue is two fold;
The labels I have inserted above each table item are not printing on any other page except the first page.
Secondly, I have three different areas where data is on the page of my report so when I use the page break = 1, it prints out all the top three table columns data first for 10 pages then it start with the next report page items for the remainder of pages.
what I want to achieve is all different table column items on one page and then move to the next page at the start of a new row of data


0 Likes

#6

Okay, I sorted out the header printing, I didn’t have my label in the header row, Thank you.

But I still cannot print all items I require on one page

0 Likes

#7

Have you added data fields from different data tables?
If no, why have you used multiple table items?
You can use one table and move data items to different cells to arrange your table, you don’t need to use grid to do that.

If your data comes from one data table, then use a single table item to represent it.

:blush:

0 Likes