report parameter filters

alien251

I have balance as a report parameter. I'd like to be able to return all non zero balances. In TSQL I would do something like this, <> 0 or !=0.. How would I do this in Navision...? :?:

Thanks!

Dan

DenSter

The balance fields are flowfields, you can't filter on a flowfield. You'd have to program the report to skip records that have zero balances.

alien251

Strange... I was able to use <>0 to eliminate the zero balance records.

JamieHurst

alien251 wrote:

Strange... I was able to use <>0 to eliminate the zero balance records.

Try setting a date filter as well.