no rowset returned error

[Buzzmeister14]

I have a report set up with CR 8.5 linking to an SQL 2000 DB

The report pulls information relating to certain policies - and works fine for certain policies - however when viewing certain policies the error

No rowset was returned for this table, query , or procedure

Is returned followed by the errorr

Error detected by database DLL

The information that the report retrieves is held in the same tables - so I am at a loss as to why the error arises

Any pointers would be greatly appreciated

 

[vidru]

Are you using a stored procedure? It sounds like you are, and it's failing for certain policies. What happens when you run the procedure from Query Analyzer?

-dave

 

[Buzzmeister14]

I am using views created in the SQL db
to pull certain information

The only other feature that may be causing the problem is that the report contains several sub reports in order to concatenate certain information

How do I run the report in query analyser?

Thanks for the reply - much appreciated