stored procedure - no fields

[scherer]

Hello,
I am working with Crystal Reports8.5 and an SQL Server 2000.
I want to make a report with a stored procedure. The procedure is o.k., it works on the sql server. But I can't add it to Crystal Reports, I get the error: there are no fields in the file:"prcedurename". In the knowledgebase on the crystal webpage I found an article, but it didn't help me. Working with other stored procedure on the same database works correct.
Please help me,
thanks
yvonne

 

[balves]

Is the final statement in your stored proc...

SELECT f1, f2, ... FROM Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer

 

[balves]

And...put this statement at the top of your stored proc.

set nocount on Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer