topic Re: Nprinting17 PowerPoint error in Qlik NPrinting

Nprinting17 PowerPoint error

dmitry909 — Tue, 31 Jul 2018 13:48:03 GMT

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:

Report creating:

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

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.

Re: Nprinting17 PowerPoint error

Lech_Miszkiewicz — Wed, 01 Aug 2018 00:46:01 GMT

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.

Re: Nprinting17 PowerPoint error

arvind_patil — Wed, 01 Aug 2018 05:21:51 GMT

HI,

Please try to add table into library again and check.

Thanks,

Arvind Patil

Re: Nprinting17 PowerPoint error

dmitry909 — Wed, 01 Aug 2018 09:57:48 GMT

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)

Re: Nprinting17 PowerPoint error

dmitry909 — Wed, 01 Aug 2018 10:00:07 GMT

Hi!

Don't works

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

Re: Nprinting17 PowerPoint error

Lech_Miszkiewicz — Wed, 01 Aug 2018 10:24:07 GMT

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

Re: Nprinting17 PowerPoint error

dmitry909 — Wed, 01 Aug 2018 14:46:20 GMT

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.

Re: Nprinting17 PowerPoint error

dmitry909 — Wed, 01 Aug 2018 15:07:18 GMT

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?

Re: Nprinting17 PowerPoint error

Lech_Miszkiewicz — Thu, 02 Aug 2018 00:53:15 GMT

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

Re: Nprinting17 PowerPoint error

dmitry909 — Thu, 02 Aug 2018 10:21:46 GMT

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..

Re: Nprinting17 PowerPoint error

Lech_Miszkiewicz — Fri, 03 Aug 2018 06:53:38 GMT

Ok then..

you need to be precise what you are trying to do..now you are mentioning pivot table - which is completely different than what you have presented in your question from the very beginning.

With straight tables i do NOT see any limitation as of now, as you can follow instructions and bring either respective fields as well as whole table, with/without source formatting.

With pivot table i will need to check and let you know. It is likely i will again record a video of what i do in my NPrinitng instance to achieve it as it will reduce time i would have to spend doing screenshot.

Please allow me some time to do this and get back to you

regards

Lech

Re: Nprinting17 PowerPoint error

dmitry909 — Sat, 04 Aug 2018 10:34:19 GMT

Sure, thank you, I hope you can get some solutions of this problem.

Re: Nprinting17 PowerPoint error

dmitry909 — Sat, 04 Aug 2018 16:36:40 GMT

Hi there!

I forgot to say. We can do this with each cell filling, we need just to fill each cell of our table.

It works in my case, but you can die before you get result if you have a big report with large tables...

Re: Nprinting17 PowerPoint error

Lech_Miszkiewicz — Sun, 05 Aug 2018 23:55:55 GMT

Ok - so here are my findings.

I am backing up my first say that product (NPrinitng 17+) works as designed. Lets just focus on Pivot table first as straight table is easier...

Scenario 1 - Keep Source Format

When using this property your object(output) should retain all formatting of the Qlik Object. This includes its layout , colours, numbers formatting etc so there should not be a need to do anything in. When using source format you should drag and drop your pivot table tag directly on PowerPoint grid (not into PowerPoint Table cell). You can control the size and look of your table directly in QlikView by adjusting column width and cells formatting.

I understand that in version 16 you were able to do this (drop table <tag> into PowerPoint table cell), but in NPrinitng 17+ you can't do this. You are right - it will throw an error.

If you disagree with this approach please open a support ticket with Qlik and let them investigate this and provide you with an answer. TO best of my knowledge this is working as designed.

Scenario 2 - Disable Keep Source Format

When you disable Source format you are able to control layout , colours, numbers formatting etc of your table. Indeed you can put then table <tag> object into a cell of a table, and your Power Point Table will apply formatting from PowerPoint. I am not big fan of this approach though.

To summerize:

The approach you are taking at the moment will not work with NPritning 17. I do not consider it a bug as to me it works as it should or at least as it "says on the box". The argument that you could control column width with approach you used to use in NPrinting 16 is against a main principal of "Keeping The Source Format" as it also should keep the column width.

I do not think i can help you more or anyone else will. My suggestion again is to contact Qlik support and raise with them your concerns.

regards

Lech

Re: Nprinting17 PowerPoint error

dmitry909 — Mon, 13 Aug 2018 05:28:03 GMT

Hi Lech!

Thank you for help! I will try to contact with Qlik support.