I have a view the sql for view is

 

e.g.

 

Select

Distinct Tab1.col1,

tab2.col1,

tab3.col3,

.......

 

inner join tab1,tab2,tab3

where condition

 

 

When I use the view in Crystal Reports XI the select distinct doesnot work instead it returns all the records ..... is this a BUG.....

 

As the same view runs fine in query analyzer

 

CR Version XI

Database Sql Server 2000

 

Thanks

Rahul