Reporting: RDLC object data source problem and its temporary workaround.

Hi All,

Here is RDLC object data source problem and its temporary workaround.

Sometimes RDLC object data source seems to work sometimes it does not, like when you just editing your RDLC or close the whole VS editor and open up it again.

MS people saying

Both Reporting Services and Visual Studio are currently investigating this problem. At this point we don't have a better workaround to offer you.

But below is general workaround for this problem.

This works for us because we use a data layer which is stored as a reference in our ASP.Net bin folder in our project

1. Right click on the bin folder and choose Add Reference

2. Choose 'Browse' then browse to the bin folder of your site and choose an existing dll

3. This will create a .refresh file underneath the selected dll

4. Check your Website data sources, choose refresh (will likely still be empty or incorrect)

5. Right click on the .refresh file and choose Delete

6. (optionally) Close/open a .aspx file from the root of your web project. This often causes a refresh.

7. Switch back to your report file, if not showing your data sources, choose refresh again - if still not showing try step 6 once more.

8. If still not showing phone microsoft tech support and spend your life on hold