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

Implementing Data Bars In A Grouped Table

by Valentino Vranken 27 May 2010 20:16
Earlier I wrote an article about the new lookup functions that ship with SQL Server 2008 R2.  Today I’m going to show you another new feature of SSRS 2008 R2, this time in the visualization department.  This feature is the Data Bar.  With this new component it’s fairly easy to make your tabular data a [...]
Click here to see the original post

Currently rated 5.0 by 1 people

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

Tags: , , , , , ,

A Developer's Blog

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

Looking Up Data On Different Sources

by Valentino Vranken 16 May 2010 12:41
Almost a year ago I wrote a small blog post to ask everyone to vote on a certain Connect item related to the linking of two datasets in a Reporting Services report.  At this moment there have been 87 positive votes on the request. Now that SQL Server 2008 R2 has been RTM’ed, it’s time to [...]
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 (194) | Post RSSRSS comment feed

Memory Dumps And Crazy Code Samples

by Valentino Vranken 6 February 2010 10:53
I usually don’t write posts just to mention a link to another site.  Except when I’ve come across articles which are so good that I want everyone to know about them.  Here are a couple of articles in that particular category. What Does Microsoft Do With Those Memory Dumps? The first one is written by Adam W. [...]
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 (125) | 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