How to create a banding report with loop pages in Nprinting

[#1]

Hi everyone!

I have a quick question related to NPrinting.

I've always created reports using the Banding Tool in QlikView, that permits to create reports with loop pages, depending on values of a table's field.

Let me explain with an example: I have a table which contains in the first column people's name and in the second column a single object bought from the single person. If a person have bought more than one object, it is splitted in more raws, for example:

Name	Object
Francis Scott Fitzgerald	Dish Soap
Francis Scott Fitzgerald	Sponges
Carl Gauss	Towels
Marie Curie	Water

I want to create a report where in each different page is shown:

- as title the name of the person;

- as table the raws related with the single person.

In this case I would have created a report with 3 pages (one for each person).

This process was automated with QlikView using the banding tool, is it possible using Excel in Nprinting?

Thank you!

[#2 · Accepted solution]

In NPrinting you'd:

1. Build a chart in QlikView like the one in your post
2. Build an NPrinting report and use the "name" field in the Page feature in Excel, PPT or the "level" feature in MS Word or pixel perfect
3. Put the chart in step 1 into the report
4. When you run the report it will make a worksheet/slide/page for each value of name and the chart should show the rows for that value of "name" only

HTH

Aran

[Ruggero_Piccoli]

Hi,

About Excel report development you can refer to http://help.qlik.com/en-US/nprinting/June2017/Content/ExcelReports/Intro-Excel.htm.

Best,

Ruggero

[#4]

Thank you Aran, it is exactlly what I menat, ad it works!