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: 
dmitry909
Contributor III
Contributor III

Nprinting17 PowerPoint error

Hello!

Recently I faced the problem, when I've trying to move my NPrinting reports from NPrinting16 to NPrinting17 version.

This problem is relevant for PowerPoint reports. So, what's wrong.

I trying to create very simple report from small .qvw application (in attachment), containing only one table in PPT template.

Simple table:

0.png

Report creating:

1.png

After that, I've create a simple table 5x5 in NPDesigner template and insert name of my object <CH01> in first row.

2.png

And when I starting the task, it fails with such error:

WARN: error during report generation: Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index

In NPinting16 this case working perfectly, but in 17 version I have big problems with my PPT reports

Who can help me with this? This is a limitation of NPrinting17? How can I use custom tables in PPT reports filling with my data from qvw?

* P.S. If I've just dropping object in PPT template, without creating a table, it works, but, it is not, what I !need.

14 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

I am not sure what you are trying to achieve by dropping whole table in the Power point Table Cell? I just think it is wrong!

Maybe instead you should use tags for fields separately, so create a table in Power point  and then add to it tags for:

  • City
  • Shop
  • =Sum(Sales)

Also ALWAYS READ DOCUMENTATION, this will prevent you from making mistakes like yours as it provides all the steps you need to take:

https://help.qlik.com/en-US/nprinting/June2018/Content/PowerPointReports/Native-table.htm

cheers


Lech

--------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
arvind_patil
Partner - Specialist III
Partner - Specialist III

HI,

Please try to add table into library  again and check.

Thanks,

Arvind Patil

dmitry909
Contributor III
Contributor III
Author

Hi, Lech!

I am trying to achieve filling of my table with values from Qlikview App table. You may think that's wrong, but it perfectly works on NPrinting16.

I tried to use tags for fields separately like a <City>,<Shop> in different cells, but I have the same problem. It doesn't work. But it works in NPrinting17.

I'am sorry, but I think this documentation is just about drag&drop technology, there is nothing about using objects or fields in already existing powerpoint tables. I mean, when in the first of all we are creating table, and only after that we put our object/field in this table.

Thank you, for your help)

dmitry909
Contributor III
Contributor III
Author

Hi!

Don't works

Already tried reloading metadata, creating new reports and templates, using different objects and deleting/adding tables to the library.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

You are wrong mate - this is not how NPrinitng works. We do not put table <tag> into table!!!

When you start dragging and droping individual tags into NPrinitng PowerPoint slide this is when you create table.

i have attached short video how to do this. You can then style this table as much as you want and it will be populated with values from Qlik

Again - Help document is very precise about what needs to be done to achieve what you are trying to.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dmitry909
Contributor III
Contributor III
Author

Lech, you are wrong in this case. Technically, there is no difference between "put <tag> into table" and "drag&drop <tag> with creating of table". It should work the same way. There is no difference for NPrinting.

dmitry909
Contributor III
Contributor III
Author

The problem is partially solved by disabling check box "Keep Source Format", without keeping format, it works.

But.. It will be pretty nice if it works with keeping source format, like it works in NPrinting16 (with keeping source format).

May be someone else have thoughts how to do this in NP17. May be it is a bug?

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Am i wrong? maybe - but you are the one who has a problem and you are the one who this functionality does not work for. I am able to create tables with custom formatting as well as with "kept source format" in my power points. I am sharing with you how this needs to be done to get the results.

First of all - you are comparing 2 different tools: NPrinting 16 and 17+ are 2 completly different tools, although at first glance they could look the same, they are not! So you cannot compare them and say it works here but it does not there!

Second thing - Help document is there for a reason, If you disagree with it and if you have your own mindset around this i do not think anyone can help you. Product works as designed!

Third thing - I understand that typing <tag> name in some cells might work but it is not completely true that it is the same as drag&drop, as designer registers also other actions when you dragging and dropping objects on template - so you can do this on your own risk but you cannot expect this to always work. This is only your assumption and you don't know what happens behind. I was working with NPrinting long enough to learn my lesson and stop assuming things without rock solid documentation. As an example i was able to achieve what you are saying only after i first dragged and dropped object on template and then i deleted <tag> from power point template and re-typed it manually.

Fourth thing -  you have never said what is the problem with the approach we were providing you? Or what result you are trying to get - The end goal is to get it working for you with the NPrinitng and all functionalities and practices it is using.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dmitry909
Contributor III
Contributor III
Author

Hi, Lech!

1) Yes, I've compare NP16 and NP17. And question is: Does it work in NP17? or How we can do the same thing in NP17? And I think it is essential thing - to compare different versions of product, to understand improvements and limitations. But what do you want to say in this point? "Forget anything you know about NPrinitng, this is a new product?" How it can help me to solve the problem? Or to understand does it possible in this version or not.

2) Help document contains an example of report building. It doesn't cover my problem. Approach, detailed in document can't help me to solve my problem.

3) Even if these approaches are different, I'am interested in implementing what I did mentioned in topic.

4) The problem is. I have a big PPT template using this technology, and I want to move it to NP17, without creating new template. If I will use drag&drop with styling, I cant manage with some problems. For example, styling pivot tables (I need different column width of pivot tables, but with drag&drop, all columns have the same size). And some other problems..