Produce empty report

[Monkeyb33f]

Hi,

We have a daily process where we create an XLS sheet if any records in our data set meet certain criteria. However, the end user has requested that in the event of no data being produced on a specific date (which happens frequently), we still create a file with just the header records, and no data.

Is this possible? Thanks.

[Lech_Miszkiewicz]

Yes it is possible

[Monkeyb33f]

Thanks - what would be the best approach to achieve this?

I was looking into whether a condition could be used? Or perhaps a template that can force it?

I'm new to nPrinting in general, so for any help you can provide I'd be grateful.

[Lech_Miszkiewicz]

If you think about it for a moment...

headers can be hardcoded as part of your template. 
so... all what you need is a dummy row with white spaces or hardspaces in your qlik datamodel so they always produce value - empty value...

that being said this becomes not an nprinting question but pure Qlik data model question, right?

...and to answer that i would need to see your data model....

[Lech_Miszkiewicz]

Your suggestion with condition can also work, although i would have to test it first... 

such solution would then require 2 conditions and 2 templates i assume. 
1st condition for when there are values so template gets populated

2nd condition where there are no values so there is a template with hardcoded headers and thats it. 

then you would need to put conditions on report level, add both reports to publish task and one of them will always be sent. 
thats it