Tag Archives: SSRS

SSRS 2008 functionality in IE9, IE10

Seems lately browsers update faster than the web solutions, or at least faster than we can update the web solutions to keep up with the browser changes. Maybe it’s just me…

Regardless, my company very heavily relies upon custom reporting. Since there were numerous changes in the way IE9 and IE10 render JavaScript DOM objects and other elements, things like SSRS and SharePoint start “breaking”. I recently handled an update enterprise-wide to IE9 by having to modify SharePoint 2010’s compatibility with IE9. Now I had to do it for SSRS, because things like the context menu drop downs on the report items were either invisible or unresponsive when clicked. unresponsive
Thankfully, Chris Snowden posted this response on StackOverflow.

Basically, you’ll need to replace your ReportingService.js file with this one. Click that link, save the file, and follow these steps:

  1. Open Windows Explorer and navigate to your server’s C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportManagerjs directory
  2. Make a backup copy of your existing ReportingServices.js file
  3. Copy this one into the same location. Make sure it’s named “ReportingServices.js”. Do not overwrite your old file just in case.
  4. Restart the SQL Server Reporting Services service on the server
  5. Clear your IE browser cache

That’s it! You should now be able to view the report item’s context drop down menu when clicked. Enjoy!
working

Eric Oszakiewski

Eric Oszakiewski is a professional software developer based in Scottsdale, AZ with over 37 years of IT experience, and 19 years Native American Gaming experience. He is currently working as a .Net/SharePoint Development Lead for General Motors.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInYouTube

Clear out old selections from “Choose a Dataset” in ReportBuilder 3

While working with ReportBuilder 3 there are times when we will move datasets around in SSRS, and old choices made when users connect to those datasets while using ReportBuilder 3 are invalid or just not there.  But the choices remain in ReportBuilder 3!  When you want to connect to these datasets, which may have the same name but just be in a different place, it’s frustrating for both the user and you.  Here’s how to remove those old dataset pointers/shortcuts from the “Choose a DataSet” window:

  • Navigate to C:users<username>AppDataLocalMicrosoftReport Builder10.50.0.0
  • Locate the user.config file and open in notepad.
  • About halfway down you will find the <RecentItem> elements under <RecentDataSets>.  Remove the entire element you don’t want in there anymore.  Note the path under the ItemPath attribute in each element to make sure you remove the correct ones.
  • Save the file and restart ReportBuilder 3

Enjoy!

Eric Oszakiewski

Eric Oszakiewski is a professional software developer based in Scottsdale, AZ with over 37 years of IT experience, and 19 years Native American Gaming experience. He is currently working as a .Net/SharePoint Development Lead for General Motors.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInYouTube