Display filters with no data

[brunomuller94]

Is it possible to display filters with no data when generating a Word report?

I know you can use getCurrentSelections() to display the current filters, but it only shows the filters that have data.

For example, if you include all months in the filter, getCurrentSelections() will only show the months that have data, and omit the ones with no data.

[Lech_Miszkiewicz]

Hi @brunomuller94 

What you are saying is not 100% true.

If you are running scheduled report from NPrinting those excluded values will be available in GetCurrentSelections(). I have tested it for myself so I know it works as it should. (note that my selection has also "c" selected but it is excluded from selection due to "A" value being also part of the filter. (I used excel report but in this case there is no difference in behaviour)

Now this behaviour is very different if you are trying to generate report using NPrinting OnDemand feature. I assume that is not a case as there is no single word indicating that you are doing it however if you were running OnDemand then the result of GetCurrentSelections() or in fact any other function would be intersection of only possible values and the only workaround would be to create such combinations in your data model.

Workaround for OnDemand report generation scenario: 

• cater for this in your data model by creating cartesian product of all required dimensions used in filter and concatenate it to fact table with no corresponding measure value. This is not ideal solution if you have large volume of data but it will "cheat the system" by creating those combinations where once filter will never exclude another.

Obviously no at this stage we would need more precise info which option you are trying to use as the one read from topic description works for me and scenario you are describing happens only in OnDemand (which you are not mentioning at all). 

let us know how you go.

cheers