Stored Procedure returns EXPR 1000
A stored procedure in SQL Server 2000 when executed from Query Analyzer returns all the fields it is supposed to. But when i set the stored procedure as a data source in a Crystal report the only field returned to the report is EXPR 1000. I am using crystal reports 11.
Any help would be highly appretiated.