Problem with RB Version 10.6 and Autosearchfield using MSSQL database

rbuser

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

nicocizik

Hi Rob,

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