I have a report designed in Crystal 8 that is ment to display the data from the stored procedure that has 1 parameter passed.

SELECT

BS.Box_Set_ID,   (int) BS.Date_Stored,  (datetime) BS.Shelf_Location, (varchar (255)) BS.NumOfBoxes,   (int) LTrim(BS.[Description])as Description ,  (varchar (255) LTrim(BS.Comment) as Comment,  (varchar (6500)) BS.Content        (varchar(MAX)

FROM Box_Set BS

WHERE ((BS.Description LIKE '%' + @KeyWord + '%' OR BS.Comment LIKE '%' + @KeyWord + '%')) AND BS.Date_Discarded IS NULL



The Procedure works fine,

however when I am designing and testing the report, when I put the comment field in the report... I get Not Supported

If I remove the comment field, It works fine.



If a co worker tries to display the report (testing) with comment field..it works fine.



I'm using Crystal 8.0.1.0 and CRW32 8.0.0.371



Software/Hardware used:
VB, Crystal8, SQL 2005