Fields from Stored Proc don't show-up in field explorer 1

[bobisto]

If the last select in stored procedure is from temporary table then the fields don't show-up in field explorer.
I've the same problem with Crystal Reports that came up with VS 2002 but I've solved with first patch. I can't believe that I've the same stupid problem with Crystal Report that comes with VS2003. I've applied the latest patches but nothing.
Please help

 

[cjlarue]

are you selecting * from your temp table in your final select? You might try using the column names.

 

[bobisto]

Thanks for the post.
Now I've changed * to column names but I still have the same problem.

 

[cjlarue]

have you tried setting NOCOUNT ON prior to your select?

 

[bobisto]

That's it. Thank you.