Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sindu_bharathi
Partner - Contributor III
Partner - Contributor III

Issue in NPrinting Report Generation

Hi All,

I have an issue in NPrinting report generation when there is no data available for the applied filters

Requirement: Individual excel reports needs to be generated for the users for their data( the application has Section access). So,for the user A he needs to see the data that is associated to him alone.

So the Filter on the Field User has been added as Recipient filter. This is working fine when the User say has data in the application.

Issue:

The problem arises when there is nodata associated wih the user, Nprinting generates reports with all the values instaed of displaying N/A in Table columns.

Is there a way, in case if a user doesn't have values then the report generated should have N/A as that is available in Qlikview instead of generating the report for all the values.

Thanks,

Sindu

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

3 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Sindu,

Take a look at the Verify filter parameter in these articles:

Filter Syntax, Parameters, and Options for Importing Recipients

How to Create Static and Dynamic Filters Based on Fields

HTH - Daniel.

sindu_bharathi
Partner - Contributor III
Partner - Contributor III
Author

Hi Daniel,

Thanks for the suggestion.

The Verify filter parameter will not generate report if the filter field does not have any associated value.

But i need to  generate the report with N/A as the column values if the filter don't have any value.

Is there a way to achieve this?

Thanks,

Sindu

Daniel_Jenkins
Specialist III
Specialist III

Hi Sindu,

Could you post a simple sample QVW (perhaps 3 section access users) that shows N/A when there is no data for a particular user? Also mockup Excel files showing what final reports you expect. That will give us something to work with.

- Daniel.