Contents tagged with SSRS

  • SQL Reporting Services 401 Error

    If you just installed SQL Server Reporting Services and you are getting a 401.1 Unauthorized error when you try to go to the http://localhost/reports this post may help.  I ran into this and was having a heck of a time figuring it out, since I assumed that since my Reporting Services Configuration Tool was all GREEN that I was good to go.  Not so. In my searching I eventually found this post which led me to my old friend, a KB article I’d already found once a week ago when fighting with Reporting Services on Vista.  My search also yielded this (more of the same). I never did get RS working on Vista so tonight’s task was to get it working on a from-scratch XP … more

  • Reporting Services Plus Vista Equals Pain

    I spent quite a few hours yesterday trying to get Reporting Services to work on my Vista laptop.  It didn’t end up working.  For quite a long time I got a login prompt when trying to go to localhost/reports, which would bomb after 3 tries and had references to several KB articles, including this one: http://support.microsoft.com/?id=907273 None of the ones listed helped.  I found plenty of others with similar problems.  I made sure to install the December CTP of SQL Server 2005 SP2 but that didn’t help.  I found this newsgroup post that seemed like it might help, but didn’t.  Perhaps it will help someone else. As it stands now, going to … more

  • Excel Pivot Chart from Reporting Services Video

    Last week I wrote about some fun I was having with Pivot Tables and Pivot Charts in Excel.  Well, yesterday I got around to recording a screencast video of how to create Pivot Chart reports using Reporting Services, Excel, and SoftArtisans Officewriter.  You can view it here: Using Reporting Services to Create Excel Pivot Chart Reports with OfficeWriter Check out our list of .NET videos, too — we’re up to a couple dozen now. [categories: video, Reporting Services, SSRS, Microsoft Office] more