Notifications
Clear all

Report filter returns with negative value

2 Posts
2 Users
0 Reactions
1,063 Views
0
Topic starter

While debugging a report, I see that certain ModelLink filter fields that are left blank return with a negative values such as -128 or -1226216161. Why does that happen?

1 Answer
0
Topic starter

This usually happens if the 'Filters' tags in the report file are defined as
<Filters bindSqlNulls="false>.

GregMerrill 2016-02-04 13:02:00

Yeah, this is a legacy flag which should always be true for any new report you create. For some reason someone thought it was a good idea a long time ago to use these "magic" numbers instead of real nulls, so this is part of our legacy codebase. bindSqlNulls="true" is STRONGLY preferred.