Data from bit field showing as -1

[#1]

Hi,

I have brought some data through from a bit field in a SQL Server database; the '1' values from the db are showing as '-1' in the table in the QV report.

I've tried changing the Number options for the field in the Table Box Properties but it makes no difference.

How do I 'mask' this data and make it show as 1?

[m_woolf · Accepted solution]

In script:

     -Field as Field;

??