topic Re: NPrinting reporting elements inside report... in Qlik NPrinting

NPrinting reporting elements inside report...

patrik_seger — Tue, 30 Aug 2016 12:32:44 GMT

I found this excellent tutorial how to make use of dynamic elements inside the e-mail sent about new NPrinting reports.

But I need to use some of those elements inside the report (eg creation date and time, report requester and so on).

Can someone guide me in how to accomplish this?

Br Patrik

Re: NPrinting reporting elements inside report...

Tue, 30 Aug 2016 12:35:29 GMT

build a qlik view/sense variable and put the variable into the report

Re: NPrinting reporting elements inside report...

patrik_seger — Tue, 30 Aug 2016 15:06:39 GMT

Hi, thanks for the answer.

Ok, this is new to me, could you please guide me?

In the reporting mail, you could write %%Execution_Date%% to include the date when the report was created. I would like to have the same date in the footer of a report, how do I build a variable that reflects that value?

I expected to see these elements here (for a PPT report), but the only non-QlikView value is a page number:

Br Patrik

Re: NPrinting reporting elements inside report...

Stephen_Jasionowski — Tue, 30 Aug 2016 15:09:58 GMT

Patrik -

You can use a formula in the template editor to achieve this.

Something like date(today()) will do the trick. Adjust the date format in the expression as needed.

After creating the formula, just drag and drop it like any other element into the desired location in the report.

More info here: Formulas ‒ Qlik NPrinting

Re: NPrinting reporting elements inside report...

patrik_seger — Tue, 30 Aug 2016 15:15:23 GMT

Thanks for the suggestion, it will help solve that one.

I though need more than this (I picked the wrong example ), I also need to put the requester for the report (On Demand)...

Br Patrik

Re: NPrinting reporting elements inside report...

agomes1971 — Tue, 30 Aug 2016 15:16:18 GMT

Hi,

please see this

dynamic report name in nprinting excel reports‌

HTH

André Gomes

Re: NPrinting reporting elements inside report...

patrik_seger — Tue, 30 Aug 2016 15:24:42 GMT

Hi André

Yes, you could resolve the report name if you know how its composed (and you have the data available in QlikView), but its still not the same as just using %%File_Name_XXX%%...

Br Patrik

Re: NPrinting reporting elements inside report...

Tue, 30 Aug 2016 15:24:46 GMT

Patrik,

The requestor can be inserted into the report name through the dynamic naming feature.

I don't think that it's possible to get the requestor's name into the report itself.

Re: NPrinting reporting elements inside report...

patrik_seger — Thu, 01 Sep 2016 07:44:56 GMT

Until I know for sure, I mark this as assumed answered (see answer from Aran below).

Thanks for the response!