Put Some Images On Those SSRS Reports

by Valentino Vranken 7 July 2010 16:05
On the forums I now and then encounter questions regarding images on SSRS reports.  Instead of re-inventing the wheel each time, I decided to write an article about the subject.  So in this article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (76) | Post RSSRSS comment feed

Your First OLAP Report

by Valentino Vranken 24 January 2010 14:28
Introduction This article is aimed at report developers who are used to develop reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Services 2008 with data coming from an OLAP cube running on SQL Server Analysis Services 2008. The OLAP [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (154) | Post RSSRSS comment feed

SSMS Showing Incorrect Version Numbers In Object Explorer

by Valentino Vranken 9 January 2010 22:21
Ever since I upgraded to SQL Server 2008 Service Pack 1 I noticed that the Management Studio was reporting incorrect version numbers when connected to Integration or Reporting Services.  This incorrect version number is located to the right of the server instance in the Object Explorer. As usual, a picture says so much more than … [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (150) | Post RSSRSS comment feed

Reporting On Data From Stored Procedures (part 2)

by Valentino Vranken 21 November 2009 20:59
Introduction In a previous article I announced that I would write a sequel covering how to pass multiple-value parameters from a SQL Server Reporting Services report to a stored procedure.  So that’s what I will be writing about in this article. As usual, I will be using the AdventureWorks2008 sample database (running on SQL Server 2008 SP1), [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (138) | Post RSSRSS comment feed

Reporting On Data From Stored Procedures (part 1)

by Valentino Vranken 10 November 2009 12:35
Introduction The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The dataset can use a SELECT query, which is the most common way of retrieving data and one that you’re probably already familiar [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (109) | Post RSSRSS comment feed

Pie Chart Techniques

by Valentino Vranken 25 October 2009 13:26
A while ago I wrote an article called Chart Optimization Tips.  This article explained how to optimize a Column Chart.  Today I have returned to show you some Pie Chart implementation techniques. As usual, I will be using the AdventureWorks2008 database, available at CodePlex.  The chart itself will be implemented using SQL Server 2008 Reporting Services. Retrieving [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (483) | Post RSSRSS comment feed

Adding an Else to your Switch

by Valentino Vranken 14 September 2009 18:11
Two commonly-used functions in Reporting Services are the IIF() and the Switch().  These are two functions of the Program Flow type, or Decision Functions as they are called on this MSDN page.  In case you’re wondering why it’s so difficult to find a function reference for the built-in functions of SSRS, it’s because these are [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (434) | Post RSSRSS comment feed

Report Builder 2.0: Cannot switch data source

by Valentino Vranken 12 September 2009 08:43
I came across an issue when playing around with Report Builder 2.0.  I had created a report using an embedded data source.  Once I’d published the report to the report server, I couldn’t get it to run anymore.  Instead it gave me the following error: This report cannot be run in report builder because it contains [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (166) | Post RSSRSS comment feed

Chart Optimization Tips

by Valentino Vranken 20 July 2009 13:40
Here are some optimization techniques that can be used when creating charts in SQL Server 2008 Reporting Services.  These tips will probably be already known to experienced chart developers, but freshmen charters may spent some time searching how to achieve something before actually finding it, if finding it at all.  I know because I’ve been [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (432) | Post RSSRSS comment feed

Want to link datasets? Please vote!

by Valentino Vranken 13 June 2009 13:22
Now that the European Elections are over once again, I’d like to draw your attention to another request for voting. Using Reporting Services 2008, at this moment it is not possible to link two datasets.  Linking datasets would be really interesting in certain cases.  Imagine you’ve got two datasets, used in two different report data regions.  [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (397) | Post RSSRSS comment feed