Friday, June 29, 2012 12:29 PM
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.
Friday, June 29, 2012 3:24 PM
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.
- Marked As Answer by vonbalaji Friday, June 29, 2012 3:24 PM
Saturday, June 30, 2012 9:39 AMModerator
Thanks for posting and sharing your solution. I believe this thread will help more people who face with the same issue. Thanks again.