What is special about -1? A bit, in SQL, is either 0 (false) or 1 (true) and that is how it would map to a checkbox in SSRS. If you are working with a VB-like language, such as Access macros, then VB true's are -1. Thus you should be treating the values as Boolean
and not as numeric values. A boolean value can be mapped to a SQL bit easily irrelevant of what the underlying numeric value is.
Why doesnt the checkbox result in a value of -1?
Lopez, Ahiezer
236
Reputation points
I am checking the boxes of these fields but for whatever reason the the value doesnt result in -1.
Every single box i check returns a value of 0. What can I do so that I get the -1 value of a checked box.
One thing to note is that the table from which this field comes is linked to an SQL server.
1 answer
Sort by: Most helpful
-
Michael Taylor 53,316 Reputation points
2024-07-19T18:00:59.6966667+00:00