Bit data type format

[iolaper]

I have a SQL server 2000 database where there is a column called IsLead that is of type 'Bit' and has values 0 & 1. There are NULLs too but I don't know if that is the problem.

When I try to view those values in MSTR while making it a filter the data does not display properly.
Also on the reports it seems to be increasing the column heights. It shows the value '1' in that column on the report but it increase the column height of all the rows associated with it.
What is the problem?
The attribute has been defined in NUMBER format. Should be TEXT?

Any help / suggestions will be greatly appreciated.

Thanks

 

[iolaper]

Well I just figured out that it was not performing a join so actually it was replicating the columns and grouping by the IsExecuting which made it appear as if it was giving huge spaces. But now I am trying to make a select distinct so that the data wont replicate..will keep you all updated!!