Problem with RB Version 10.6 and Autosearchfield using MSSQL database
Hello,
I have linked the reportbuilder to MsSQL2000 and have a report with a table
where I want to have an autosearch criteria where Paid=False; that works
well with an acces and a MySQL database but with the MSSQL database I get an
errormessage saying Colum False not found, it also occurs when I say Paid=0,
Paid='False', Paid="False".
What to do?
Regards
Rob Nowee
I have linked the reportbuilder to MsSQL2000 and have a report with a table
where I want to have an autosearch criteria where Paid=False; that works
well with an acces and a MySQL database but with the MSSQL database I get an
errormessage saying Colum False not found, it also occurs when I say Paid=0,
Paid='False', Paid="False".
What to do?
Regards
Rob Nowee
This discussion has been closed.
Comments
What is the datatype of the Paid field? Note that SQL Server does not
support a boolean datatype. If this is a Bit datatype, you will need to use
1 and 0 as True and False respectively.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com