Connecting Tech Pros Worldwide Help | Site Map

How i know if a report has Data in Reporting Services 2005?

Newbie
 
Join Date: Jul 2009
Posts: 11
#1: Aug 5 '09
I need to know if an especific report has Data, becouse i have an application which communicates with Reporting Services through a web Services and on some occasions the web services run a report and it don't have any data, in this occasions i need to do something specific, but to handle this situation, i need something to tell me when a Web Services don't found Data.

I Try to MetaData of ReportingServices but it does not work, because if a have some DataSet in one Report, it tells me all the row of all DataSet.

Can anyone tell me any other alternative?

Regards
ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Aug 7 '09

re: How i know if a report has Data in Reporting Services 2005?


If your report is based on a table, view, table-function or query, you can do a exists() check to see if it will return a result set.

Good luck!!!

--- CK
Newbie
 
Join Date: Jul 2009
Posts: 11
#3: Aug 7 '09

re: How i know if a report has Data in Reporting Services 2005?


i don't understand, where i can use exist() method, remeber that i execute the report throuth a WebService, it return a bytes array that represent the reports. I used webservice.render() method. I used a webservices becouse the reports are run through a VB.net Application, so, i invoke the report through a Reporting Services's WebServices, and it return a byte array that represent the result of the reports, but the array byte alway bring byte because, the reports has a header, hence occurs bytes.
Reply