More on SharePoint “...

Following up my initial post on the SharePoint “User not found error with Reporting Services in integrated mode, I wanted to post another reason for the “User not found” error. If, somewhere in the site author tree, you have user accounts that no longer exist, you will encounter the “User not found” error while viewing the report and browsing the list of shared data sources. I...

6 little things I don̵...

I’ve been using Windows Server 2008 since it was released in February.  In general, Server 2008 is a huge improvement over 2003, however, there are a number of little things that annoy me, all of which are also found in Vista.  I plan to talk later about my favorite features in Server 2008, but I’ll start with my pet peeves: 1. Folder icons have been turned sideways I understand this was done...

T-SQL missing comma in SEL...

I ran in to this “gotcha” the other day while writing a number of views. I omitted a comma on my SELECT statement, and the parser did not return an error, but rather just results that I did not expect. The problem is that SQL Server interprets the missing comma as an implied column name. It is as if there is an unwritten “AS” where the missing comma should go. Screenshots of the...

Sorting via parameters in ...

In SQL Server Reporting Services (SSRS) there are two different methods for a user to sort their reports after they have been generated. Other folks have done a superb job of explaining each method, so I’ll just point you to their sites: The user can interactively sort on a header textbox by just setting the “interactive sort”...

Free alternatives to DNSRe...

I used to use the DNSReport from DNSStuff.com, but it seems like they are making it harder to use. I researched some alternatives and I came up with these two that I liked the best: IntoDNS: http://www.intodns.com/ World Wide Web Domain Tools: http://w3dt.net/tools/dnsreport/ Here’s a more exhaustive list with reviews of free alternatives to DNS...

Group by month, year, or a...

I found an excellent example of how to group by month in a blog recently. It does require using SharePoint Designer, however. An alternative to grouping this way is to create a calculated column and group on that. The end result looks something like this: : Basically, you just create a new calculated column in the list.  My original column was a DateTime called “Published”.  I created a new...

Mapping with Virtual Earth...

After seeing an excellent article by Wayne Berry about Mapping in SQL Server Reporting Services using the Google Maps API, I was inspired to see what I could do with Virtual Earth. The answer: not much. Virtual Earth does has a stellar SDK. The SDK is all JavaScript based, so it may not be used by SQL Server Reporting Services. Virtual Earth does not have a static mapping API. However, there are...