Analysis report: "if any column Not Zero" is not filtering

lili14
lili14 Member Posts: 11
edited 2015-08-03 in NAV/Navision Classic Client
Hello all,

When using the Analysis report the option "if any column Not Zero" is not filtering when exporting to EXCEL. I tried adding the following code to the report "Export Analysis Rep. to Excel (7113)":

AnalysisLine.SETFILTER(Show,'<>%1',AnalysisLine.Show::"If Any Column Not Zero");

But when I use SETFILTER I don't get any lines anymore(with or without values). any thoughts?

Thanks,

Comments

  • aseigle
    aseigle Member Posts: 207
    If I'm not mistaken we came across this several months ago and found a KB article from Microsoft to resolve this. I don't have it handy, but you can search the KnowledgeBase for it.

Categories