Error From Dataset - No Rows - OLEDB Driver

All,

I'm getting a strange error in SSRS when there is no data returned from a OLEDB datasource.

Here are the steps to simulate the error

1. Create 2 shared datasources to the Adventure Database - one using ADO MD provider (Microsoft SQL Server Analysis Services (AdomdClient)) and another using OLEDB (OLEDB 9.0 for Analysis Services)

2. Create a new report and create a dataset with the ADO-MD provider and copy and paste the below query. (This query will not return any data)


SELECT NON EMPTY [Measures].[End of Day Rate] ON 0 ,NON EMPTY {[Date].[Date].&[10000]} ON 1 FROM [Adventure Works]


3. Run report. It will be blank as nothing is defined in the layout. But this shows that the query is executed in the dataset and is succesfull although the query does not return any data.

4. Create another report and create a dataset with the OLE-DB provider and copy paste the above query.

5. Run the report. It will come back with error in the lines of "Object reference not set to an instance of an object". The reporting services log file will show that the query execution has failed although this is not the case when analysed from profiler.

Any ideas on how to solve this? What I'm trying to acheive is to use the NoRows property of table to display a message when there is no data. But I'm not able to pass the above hurdle when no data is returned from the dataset.

Thanks in advance.
Arun.