ReportViewer Website Data Sources Pane Suddenly Shows As Empty

It Was There A Moment Ago

I was happily using the excellent and free ReportViewer add-on Control when suddenly I noticed that the Website Data Sources Panel was blank. This is a Category Orange catastrophe for ReportViewer as it means that you can no longer easily add data items to the report without hacking the rdlc file.

Risking Anaphylactic Shock
I responded to this issue with my normal professional saviour-faire, entering an insane frenzy of clicking every available menu option interspersed with hyperactive Googling and masking my sweaty fear by eating handfuls of peanuts.

Just as I was about to sacrifice my emergency sacred ferret to a graven image of Bill Gates I fluked a gigantic ‘WHAT-THE’ on one of my semi-random Menu options. When selecting Report->DataSources from the Visual Studio 2005 main menu (NB you must be currently editing the rdlc file for this menu item to be visible) I got this error message:

“Cannot compile ajaxtoolkit.dll”.

Now, our Web Project has a reference to ajaxtoolkit.dll in the Bin folder which always throws a Compilation Warning. Could ReportViewer be touchy about this ? So I excluded the offending dll from the Project, recompiled the project et voila,…nothing happened…ONLY KIDDING!!.. WebSite DataSources came flowing in as contentedly as obese Policmen to a Krispy Kreme franchise.

Replicating The Problem
1. Have a bad Reference in your Bin folder e.g. put in the wrong path to a dll
2. Edit any DataSet that currently shows in your WebSite Data Sources Window in Visual Studio XML editor (e.g add a new column to a DataTable)
3. Recompile your app.
4. WebSite Data Sources Window goes blank.

Fixing The Problem
1. Exclude the bad Reference from your project
2. Recompile
3. WebSite DataSources return
4. Return emergency ferret to cage.

Others On The Journey Of Pain
Fellow desperado gtrfinder also had to kill bad dlls to make his Website Data Sources Window populate. Others in that ASP.NET Forums thread report various workarounds. Good Luck!

What Is This Thing Called ReportViewer ?
Its like a baby brother to SQL Server Reporting Services Reports, but you don’t need SQL Server. The only dependency is the .NET 2.0 (or better) Framework. Nice for a free Reporting Solution for .NET. I got onto it while hunting for a way to easily do Drill-Down Reports in .NET. It ships with Visual Studio 2005 and 2008. Here’s the MSDN write-up with some getting started tutorials.

Advertisements

Tags: , ,

6 Responses to “ReportViewer Website Data Sources Pane Suddenly Shows As Empty”

  1. Hoodah Says:

    thanks for the post. helped me. it turns out my bad “reference” was a web reference so it was really hard to narrow down. not to mention the fact that fixing it is out of my control.

  2. Dani Says:

    You are the king!!!
    Thanks,
    I was suffering a @#$^ ake and now it’s gone πŸ™‚

    • baraholka1 Says:

      Dani –

      A @#$^ake sounds terrible.
      It is certainly difficult to type πŸ™‚

      Very happy to help.
      Keep on Biting!

      Regards,

      Barra

  3. Yu Casey Says:

    Comfortabl y, the article is actually the best on this worthw hile topic. I harmonize with your conclusions and will thirstily look forward to your future updates. Just saying thanks will not just be enough, for the great clarity in your writing. I will immediately grab your rss feed to stay informed of any updates.Pleasant work and much success in your business endeavors!Thanks.

    • baraholka1 Says:

      Yu,

      Many thanks for your encouraging comments and for your link to the grotesque picture of an inflamed Appendix. I assume this is what your Journey Of Pain “ReportViewer DataSource Pane Empty” issue did to your internal organs ? Other Tadpolers are strongly encoured to click on Yu’s link, if only for its bizarre title “Symptoms of Saying The Appendicitis Inflammation”.

      Kind Regards,

      Barra

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: