ReportViewer & ASP: How do I know there is no data in the report?

[jogro]

I am using the ReportViewer DTC on an ASP page. My report uses a stored procedure. I setup all the parameters etc, connect to the DB and then if there is no data how do I know?

doing a session("oRpt&quot.ReadRecords causes a timeout (I think, no errors though).

In VB you could use the NoData event.

What can I do so that the viewer does not get launched on no data?

 

[synapsevampire]

One way might be to have the SP return an error or something showing a zero row count.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[D1000]

Did you find a solution to your problem?

We are facing the same issue - trying to determine whether or not a report returns no data without the NoData event. Our program does not have a UI and thus, we cannot trap for that event.