topic Re: How to export multiple reports within single excel using Nprinting extension objects? in Qlik NPrinting

How to export multiple reports within single excel using Nprinting extension objects?

srinivas1921 — Sun, 27 Nov 2016 16:33:30 GMT

Hi All,

We are displaying multiple reports in single qlikview sheet using straight table. All reports names we are displayed in a multi box object at the top of this chart and when user select particular report from multi box then that report results will be displayed in the chart. So all reports results will be displayed in single sheet only. In our report there is huge data is there.

As per our requirement, how to export all reports in single excel with sheet wise separately.

Plaese provide the solution on this.

It is very urgent requirement........

Many thanks in advance for u r support......

Thanks......

Re: How to export multiple reports within single excel using Nprinting extension objects?

lironbaram — Sun, 27 Nov 2016 19:51:47 GMT

there is a very easy solution it calls Qlik nprinting

Re: How to export multiple reports within single excel using Nprinting extension objects?

srinivas1921 — Mon, 28 Nov 2016 02:37:51 GMT

Hi,

Thanks for u r quick response. I have able to export one report into excel using Nprinting extension objects but I am trying to export multiple reports at a time sheet wise.

Please provide me solution on this. It is very helpful to me if u r provide any example on this.

Re: How to export multiple reports within single excel using Nprinting extension objects?

lironbaram — Mon, 28 Nov 2016 08:19:57 GMT

it's actually should be quite simple

you need to use the page functionality

and use your report field as the field for paging

i'll try to create a demo later

Creating Excel reports ‒ Qlik NPrinting

Re: How to export multiple reports within single excel using Nprinting extension objects?

srinivas1921 — Mon, 28 Nov 2016 09:47:48 GMT

Hi Liron,

I have created excel in the NPrinting Designer and as you mentioned that I have used Paging functionality to display multiple reports sheet wise.when I ran this task from NPrinting Designer then I able to produce the all 12 reports within single excel only.But when I trying to export all reports using Extension objects then I unable to produced same results from QlikView report.only I able to export single report which is selectable in the report.

I am trying to export rest report as well within same excel.I thought that NPrinting extension objects doesn't allows paging functionality.is it correct? If am wrong then why NPrinting extension objects doesn't produced all reports within single excel.

Thanks.....