CodingPleasure

cultivate passion for everything else that goes on around programming

Reporting Services Adventures

I starting working with Reporting Services 2008 in a project at work. I didn’t really knew much about the whole technology around SSRS, but after some weeks/month of researching I managed to get everything working.

The customers’ requirements were not that trivial. Starting from “simple” ones like multi-language and up to more difficult ones like reports getting data from multiple databases, I learned that there are a lot of options and different ways to implement reports.

The journey began, like every project, with the client’s whishes, listed in a document, known as the specifications document. The main requirements were:

  1. Reports should be viewable via a web browser.
  2. The same report, viewed by different users, should display different data.
  3. Users must be able to create their own reports.
  4. Multi-language: reports should be localizable.

Broken into smaller pieces, each requirement has been investigated and possible solutions were analyzed. After some Internet researching, some e-books and even a printed book (in German language), I have gathered some answers to some of the problems, but unfortunately even more questions than I expected. The difficult part was that I didn’t have enough experience with reporting tools (I played with Crystal Reports some years ago, but never did any web based reports). Diving into the SSRS technology, I begun to understand the concept behind a report server, why someone should use it after all and what the benefits are.

During the research, I gathered a list of useful links:

  1. How to set up Report Manager to start Report Builder 2.0 as a ClickOnce application: http://msdn.microsoft.com/en-us/library/dd795295.aspx
  2. Information about Connection Strings in Report Builder (event expression based connection string) http://msdn.microsoft.com/en-us/library/ms156450.aspx
  3. Howto start Report Builder using parameters: http://msdn.microsoft.com/en-us/library/ms345245.aspx
  4. Howto customize the ReportViewer control using URL parameters http://msdn.microsoft.com/en-us/library/ms152835.aspx
  5. Blog about SQL Server Reporting Services http://blogs.msdn.com/bobmeyers/

Coming next: information about (almost) every problem I stumbled upon using SSRS.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: