sp with temptables doesnt work in crystal reports

[Lost User]

Hi, I have written a stored procedure in SQL Server which uses temp tables and returns the rows of a temptable. When i try to use this sp as datasource for Crystal report(Add Database), the fields are not listed. Why is that? If this wouldnt work how do i implement this. Am using a custom version of crystal report bundled in VS .NET. Any help would be appreciated. Thanks in advance Geetha

[WoutL]

This article could help: PRB: Error Messaging Referencing #Temp Table with ADO-SQLOLEDB[^] Wout Louwers

[Geethalakshmi]

Thanks for the help. I use VB.Net, ADO.Net to execute the stored procedure. Even if i use "set noCount On", am not able to create the .xsd file. Pls tell me how to implement it in .Net? I want the .xsd file to be created. Thanks in advance.