Hide excel sheet in final report (pdf) if no data to show

[Jorge_FR]

Hi everyone,

My client has tasked me with creating a PDF NPrinting report from an Excel model. One of the Excel sheets includes a table that displays the sales amounts exceeding 100K. However, for certain sellers, this table does not have any data.

My client has requested that I exclude this page from the PDF report if such cases occur.

My question is: Does NPrinting offer a feature to accomplish this action?

Thank you!"

[Lech_Miszkiewicz · Accepted solution]

Hi @Jorge_FR 

no - there is no such native functionality. I can think of workaround though...

I assume this report create file for each seller, if so you can:

• build that raport and duplicate it so you have effectively 2 templates (1 with that page and one without it)
• You can setup 2 publish tasks with Advanced Search filter to put sellers which have data with sales >100K against one task and others against the other task. 

I dont know if this solution is acceptable as we dont know if you apply cycle functionality or whether you use user filters or maybe section access to create sellers reports and for each of those scenarios approach may be different.

Lastly - I would say - since output is PDF maybe you need to consider PixelPerfect report which has ability to hide/show segments of reports based on condition

[Jorge_FR]

Hi @Lech_Miszkiewicz ,

Many thanks for your reply.

I will conduct some tests to determine the best option to present to my client.

Regarding the option of using two templates:

Would using cycles (Dept and Seller) to generate the reports change the approach of using an advanced filter?

If I understand correctly, it is the advanced filter on the publish task that will allow NPrinting to switch templates if the condition > 100k is met?

[Lech_Miszkiewicz]

Well, yes - it will change the result. 

Using cycle causes creation of a single ZIP file with all combinations of cycle fields and values as separate reports in it. 

If we are going to create 2 templates we will create 2 separate zip files - each having separate set of reports.

Since you are cycling over multiple dimensions your advanced search filter will need to be based on concatenated field composed of those 2 dimensions as only then you will be able to ensure correct results.

[Ruggero_Piccoli · Accepted solution]

Hi,

I agree with the suggestion to develop a PixelPerfect template. It is optimized for PDF output and it has formatting rules that allow you to hide bands on certain conditions but it requires a new template. Getting PDF from Excel templates is supported but you have always to do test and update because Excel is not made to manage the layout of "printed" documents. 

You can also evaluate conditions https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Conditions.htm. You can create 2 Excel templates, one with the table and another without, and add them to a task one with the condition false and the other with true so only the correct one will be sent.

Best Regards,

Ruggero

[Jorge_FR]

Dear @Lech_Miszkiewicz  and @Ruggero_Piccoli ,

Thanks so much for your valuable input.

I will proceed with conducting tests and implementing the approaches you proposed.

I truly admire the supportive and knowledgeable community here.

Once again, thank you both for taking the time to share your insights.

Best Regards,

Jorge