Crystal Reports Error--No Rowset was Returned for this table, query.. 1

[alan12345]

Hi All:

My Crystal Report uses an MS SQL Query that has a nested stored procedure in it.

The calling sproc creates a permanent table then does an

insert into PermTable
exec sested sproc

I found that I can do this without temp tables. I just need to do appropriate drop tables in the calling sproc.

This calling sproc with nested sproc runs fine in MS SQL Query analyzer.

But when I try to use in Crystal Reports version 8.5 using OLE DB, I get:

"No Rowset was returned for this table, query, or procedure."

The only way it works with Crystal is to use an ODBC connection which we do not want to do.

How do I get it to work with Crystal/OLE DB?

Thanks!
Alan

 

[ClayG]

Try

Set NoCount On

at the start of the stored procedures