Issue in NPrinting Report Generation

[sindu_bharathi]

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

[Daniel_Jenkins · Accepted solution]

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]

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]

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.