Publisher & PDF distribution just loop (no reduce)

[p_verkooijen]

Hi,

We use the Publisher with PDF generation to create Store reports for a client.

Most reports work fine however we got some reports which report over the looped store but also giving info about national and regional numbers.

When using the loop & reduce my data is reduces to store data only, so I can’t use this option. When using the loop through field in the report it creates 1 big PDF with all pages included

Thought of a way to use a lose table in the loop and reduce, with expressions altered to use this as the Store input.

However my document contains info of 314 stores and its size is already 1Gb (Current and Last year data).

The loop and reduce does no clean-up during the loop/reduce but afterwards what would lead to a Temp storage 314Gb of data.

Any ideas ?

[#2]

Paul,

Did you find a useful solution for this issue?

[p_verkooijen]

Hi Mehmet,

Contacted Qliktech support / account manager and a QlikTech consulant, however no resolution within Qlikview.

Our useful solution is using a third party solution instead of the Qlikview PDF generation for this report.

[#4]

I cannot believe that! Can you share the name of the tool? (NPrinting?) And can this tool make exactly what you need?

Thanks in advance.

[p_verkooijen]

The only solution provided for showing the regional / national numbers was to build a additional table with this data snowflaked from the original data. In such a way that reducing the data would not be a issue.

Because of the temp disk needed this is no option, also the impact needed to create this additional table is far to high.

Nprinting could do the trick, we have developed a simple "tool" that can satisfy our needs regarding distribution of PDF reports.

Take a look at this thread Macro to export AND mail report as PDF

[jaimeaguilar]

Hi,

It is true that the native pdf reports are not a robust solution. However, before considering using a third party solution (like NPrinting) you may try all possibilities within native reports.

It may be possible to create reports the way you need it, but first I would like to understand your requirement.

So you're saying that you need to generate a report for every store or a report that includes information about all (or some) stores? also it would be useful if you can upload a screenshot of your data model or list the involved dimensions, in order to get a better context of what you need,

regards

[#7]

Hi Paul,

I did it as your "snowflaked" suggestion.

I posted on my blog; PDF Distribution with no reduce using QlikView Publisher | Mehmet's Personal Blog