failed to open a rowset

[nenuaky]

Hi,

I have a report that uses stored procedure,When ever the procedure returns zero number of rows . the report is throwing an error 'failed to open a row set' . Im using CR 10 , sql server 7 and ODBC connection.any help

Thanks
AK

 

[Turkbear]

Hi,
Since the rowset depends entirely on the output of the SP, that is a 'normal' result if no records exist..
Try this ( not sure it will work, but..):
Place a field in your report that always will have data
( Like a Sql Expression that returns the Current Date)

Place a test for a Null value from one of the fields in your SP's return set and display a message that no records were found if true.






To Paraphrase:"The Help you get is proportional to the Help you give.."