April 2007 Entries

SQL Reporting Services

50% of my job is Web Development. The other 50% is managing a 2GB SQL database and web app (with about 1500 users). Part of that 50% is writing SQL Reporting reports. Up until the other day, I was having my users log into the web interface of S/RS and get their reports that way. I was talking to some other developers who use the same system, and they said that you can Proxy into reports using code. I dug into this a little bit, and in about 2 hours, whipped up a little VB.NET page that did the trick....

A strange thing happened to me on the way to work today...

So, I wrote a new web service in a .NET 2.0 app today. Went to fire it up, and I got a wierd message that I had never seen before. I found a few references to this on the web, but they all dealt with 1.1 stuff. Then, I went hunting around my web.config to see if there was some way it was trying to emulate 1.1. I ran across this line that I put in when I decided to mess around with AXAX.NET. <remove verb="*" path="*.asmx"/> Whoops. I had inadvertently disabled my web services... Yeah. Don't...