I have a report designed in Crystal 8 that is ment to display the data from the stored procedure that has 1 parameter passed.
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 126.96.36.199 and CRW32 188.8.131.521
VB, Crystal8, SQL 2005
September 18, 2009 2:23 PM
October 19, 2010 4:58 PM