I currently work in the interactive department of a advertising agency, who started a whole new green initiative. Which gave me the excuse to make the process of our jsu(job status update) a little less annoying. This system would send out emails with job related information and also client reps would print them out and hand them to you. My decision….I don’t want paper and an alternative to email (since i have limited space they have to be deleted).

This gave way to the jsu widget, we created a easy to use and fast widget. No longer would i have to wait for outlook or login into the company portal and navigate to the information. The adoption rate for this widget was fast because other people would also share the same annoyance.

Technology: Javascript, XML, and SQLServer

JSU widget for A&G

JSU widget for A&G

So this weekend was my brothers graduation and all the family came over big party the whole 9 yards. I was having a conversation with my cousin in law who is a dentist and the subject of humility in ones field came into play.

How the Customer (or Patient) would rather feel the sense that you are going to make things ok and get it done, but at the same time treating them as an equal or better yet a person. Not just someone’s that going to write you a check.

I think sometimes we loose the human interaction between both parties. For example here a situation that happen to me.

My DSL was acting up so I called tech support, person on the other end walks me through steps that they are reading off the screen. We thought the issue was resolved and i was giving a ticket. 30 min’s later my DSL goes down again, I call back and give them the ticket number and they proceed to walk me through the same step, even though I told the guy and he knew I had been through this wasting both our times. If i wanted that kind of service… i would have much rather preferred an automated system, at least an you known that the automated system doesn’t think and cant expect to much from it. And so now next time I call back I’m going to be a little negative about them helping me.

And thats the important part making the customer feel like you really tried to help them not that there just an Item in Queue…even if they are just an item in queue.
…this is the end to my rant

I found these two articles very informative, In many of my project the user log in through a form and are validated against AD. From there i would create a NetworkCredential that i would pass to the sql reporting webservice. This is another method you can use to provide sql reports with out having to hit add.

Using Forms Authentication in Reporting Services:
http://msdn2.microsoft.com/en-us/library/aa902691(sql.80).aspx

Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider
http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx