topic Re: Common report in Qlik NPrinting

Common report

markp201 — Thu, 11 May 2017 19:34:06 GMT

We have three reports which only differ by a filter and report header.

Can the report header be dependent on the filter? I thought setting up a variable or adding a column to a report - something to feed the header

We'll have 3 report objects with their respective filters but they all share the same template.

Know what I mean?

Re: Common report

ogster1974 — Thu, 11 May 2017 20:12:01 GMT

Have one report and 3 publish tasks. apply the filter to the task. you can give the report a friendly name in the task itself when adding the report.

Regards

Andy

Re: Common report

Anonymous — Thu, 11 May 2017 20:17:39 GMT

Can you provide more detail? There are multiple possibilities but it depends on what your filter is, whether you want separate files for each report or whether they are different tabs in the same workbook, how the header is different.

You might be able to use a cyclic field at the report level.

The column names could be dynamic based on variables in Nprinting.

Re: Common report

markp201 — Thu, 11 May 2017 23:54:09 GMT

With the exception of a header which is dependent on the filter, everything is the same. What I've done so far is create a column with a small expression to build the header. So far it works but I would prefer a simpler solution - variable maybe. I've read that textbox are passed as an image so not digging that idea.

Re: Common report

ElizaF — Fri, 12 May 2017 05:32:08 GMT

Hello Mark,

If I understand correct your request, you can use GetFieldSelections function for header reports or columns label.

See the attach file.

Re: Common report

markp201 — Fri, 12 May 2017 12:01:57 GMT

Yes, that's exactly how we resolved this issue. Great minds...

Re: Common report

ElizaF — Fri, 12 May 2017 12:25:33 GMT

My pleasure .

I am glad it did help.