SQL Server Reporting Services “interal error occurred”

If you work with SQL Server Reporting Services (SSRS) 2005 for any length of time, you’ll see a number of ambiguous error messages.  I recently ran into the error below and found the solution quite easy.  Maybe you’ll encounter this one day and I’ll save you some headache. An error...

Non-queried multi-value parameters in SQL Server Reporting Services

As a follow-up to my previous post on Easy multi-value parameters in SQL Server Reporting Services, I wanted to point out some information on non-queried, or static multi-value parameters. For my example, I’m using a parameter named “Time” with choices “Morning”,...

More on SharePoint “User not found” error with Reporting Services

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...

Sorting via parameters in SQL Server Reporting Services

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...

Mapping with Virtual Earth in SQL Server Reporting Services

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...