Hi, I have encoutered a very strange problem. Created a .rdl file with the datasets ( Summary and Total) and executed in the BIDS 2008. I am able to get the actual report with the data. I am showing SSRS reports designed with xmlns 2008/01, having two datasets say Summary and Total and displaying in the report viewer ( assembly version 10.0.0.0). Datasets are added to the ReportViewer.LocalReport.DataSources and I can see the data on the data sets ( via debug. Summary shows 15 rows and Total shows 1 row). until now all are ok. But when I call ReportViewer.RefreshReport(), I can see only the Total value displayed in the rendered report. I passed only total, not passing summary, report did not throw any error. but the other way around, passing Summary w/o Total, while rendering, exception was raised saying Dataset Total missing. I chcked with LocalReport.GetDatasourceNames(), which shows two DataSources, Summary and Total. I added a expression to display the row count of Summary in a text box, to check whether the Report Datasource has got the data. Suprisingly the result was 0. But when I debug with (LocalReport.Datasources["Summary"].Value).Rows.Count shows the count as 15. Could you please shed some light on what went wrong and where ? Much appreciated your response. Note: I am showing rdl file via LocalReport, which I used to do with other working reports too. Thanks

All, I have checked other questions with SSRS and most of them suggest to have the report rebuilt in case of any strange errors like this. Since I have already wasted around a day in investigating the issue, I re-built the report again from scratch.(but still copied the tablix and other text boxes from the old report itself, which saved me a lot of time). Hurray... It worked with the new report.... I compared both the old and the new files and I can't see any major difference between those files. Suggests you, if you have any strange problem like what I have had with SSRS, it's faster to re-create the report and which will work. Thanks

Hi vonbalaji, Thanks for posting and sharing your solution. I believe this thread will help more people who face with the same issue. Thanks again. Regards, Mike Yin TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.