Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
coreyhartman
Contributor II
Contributor II

NPrinting - possible to page on a field and include overall summary?

Hi All,

I've been searching for a way to create an Excel Report for NPrinting On Demand which has summary information in a table at the top of the report, followed by another table which pages by a specific field. For instance, say I want the end user to select a Sales Region, and then print the report. Then I would want the report to show cumulative numbers in the expressions of the table across any dimensions for that region, and then below go into detail and page by each Sales Person associated with that region. Is this possible and I'm simply missing something? I believe it can be done with QlikView's native reporting... but I haven't yet found a way to accomplish it in NPrinting. I can get the report to page by the Sales Person but I can't get it to leave the summary table alone. Alternatively, it would work if I could level by the Sales Person instead and repeat a page break within each instance of the level range... but I couldn't make that work either. I tried adding a page break within the level range but it only recognized it once and didn't repeat.

Any help would be greatly appreciated. Thanks!

Corey

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

Hi Corey,

QlikView NPrinting allows you to add paging to a particular Excel sheet. How to Use the Page Feature in Excel and PowerPoint Report Templates

Lets say you have a table containing Regions, Countries & Population. You could place a chart containing all details on Sheet1, place another instance of the same chart (or another appropriate chart) on Sheet2 and page by Country only on Sheet2.

I have attached a project that demonstrates this. If your On-demand user selects Region NORTHERN AMERICA & clicks Run report

QlikView NPrinting generates a report with All countries in NORTHERN AMERICA on Sheet All Countries and a separate sheet for each country

You can of course do something similar with Levels if you want everything on one sheet.

Extract to folder C:\Temp\Community\036 to preserver the paths used or change them in the nsq.

HTH - Daniel.

View solution in original post

2 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Corey,

QlikView NPrinting allows you to add paging to a particular Excel sheet. How to Use the Page Feature in Excel and PowerPoint Report Templates

Lets say you have a table containing Regions, Countries & Population. You could place a chart containing all details on Sheet1, place another instance of the same chart (or another appropriate chart) on Sheet2 and page by Country only on Sheet2.

I have attached a project that demonstrates this. If your On-demand user selects Region NORTHERN AMERICA & clicks Run report

QlikView NPrinting generates a report with All countries in NORTHERN AMERICA on Sheet All Countries and a separate sheet for each country

You can of course do something similar with Levels if you want everything on one sheet.

Extract to folder C:\Temp\Community\036 to preserver the paths used or change them in the nsq.

HTH - Daniel.

coreyhartman
Contributor II
Contributor II
Author

Thanks! I think I tried something along those lines, but didn't realize I needed to make another instance of the chart instead of using the same one. Either way, I followed the instructions in your link and was able to accomplish what I was looking for.