Using Reloadtime function in a report.

[woutermak]

Hi all,

I’m using nPrinting 17.3.

I have a QlikView (12.x) document. The reload for this QlikView document is scheduled once a day.

I send a report once a month. I use a formula in this report date(reloadtime()). The name is: Peildatum.

I use this value in my report in a string like: Report verlof for user <Medewerker> with date <Peildatum>

I send today this report, but what happened: most of the user will see:

Report verlof for Wouter Mak with date 03-04-2017

Some users will see

Report verlof for (a employee) with date 18-03-2017

How can it be that there are two different dates? It’s just one QlikView document. It’s one task which is used to send all documents to all employees. But for some employees is the date different. Can anyone help me?

Wouter

[Daniel_Jenkins · Accepted solution]

Hi Wouter,

If you are using a QVW that is being reloaded by the QMC you must use a Server type connection (qvp) in NPrinting. If you instead connect as a local connection you could get stale or mixed stale & fresh data if you do not reload the metadata (version 17.3) or restart the NPrinting services (all versions).

HTH - Daniel.

[woutermak]

Thanks Daniel!

That's it. This is also good to know. Always use the connection qvp! This will help you keep out of trouble

Wouter