Waterfall charts in SQL Reporting Services
Tuesday, June 2, 2009 at 8:12AM Recently we completed a project to build a KPI dashboard for a large Australian organisation to show certain performance measures for each business unit. The challenge was that the client wanted a very specific kind of chart, basically a waterfall chart which displays the end target/goal as the final column. Using the Dundas charts control this task would not be that difficult as we could have used a chart similar to this and made a few tweaks.
However due to the clients Reporting Services Architecture the costs of Dundas licenses was not feasible so we needed to come up with a way to produce a similar chart using the native Reporting Services chart control.
Here's what we learned:
- The chart type to use is a Stacked Column Chart
- You need to add a data value the represent the data value you want to appear in the waterfall. In our case we added the KPI actuals eg:(Fields!KPIActual.Value)
- Then you need to add the same data as a second data value to the stacked series as a running total and subtract the individual first data value at each point. We added the same KPI actual data as a second data value which would be stacked below the first but this time using a running total less each KPI actual eg:RunningValue(Fields!KPIActual.Value, Sum, "chart1_SeriesGroupKPI_Measures")-(Fields!KPIActual.Value). We also set the background colour fill for this series to white so that it would blend into the background of the chart an could not be seen
The final result was a nice clean waterfall chart that shows progress towards an end target
Reader Comments (30)
In this modern and fashionable society, people are pursuing for cheap boots cool, unique, stylish and innovative. Whether it is ugg boots cheap or fashion accessories all means a lot for modern society of today. Same is the case with trendy looking Ugg Boots sale. When these are discount uggs, the excitement just gets doubled. Most chic looking UGG Classic Tall Metallic Boots are in fashion now. These are one of the favorite fashion accessories for men and women long time ago. If you have not yet tried UGG Classic Short Boots, it's time to own one and feel the difference it can make to your personality. These are just brilliant and fabulous ugg boot sale. They are most iconic and can provide you with a new feeling and enhance confidence. The quality of uk ugg boots sale is just superior to what you have dreamt of. Today owning a new and trendy looking ugg boots on sale are not only meant for the wealthy people. These are now made luxurious and affordable ugg boots cheap to reach out to every budget and range. You can just enjoy them by ordering UGG Classic Tall Boots online where you get the complete satisfaction and genuine quality at best possible rates. The finish, quality and designs you get from UGG Argyle Knit Boots are really astonishing and you will love them all. Different styles and designs of ugg boots uk are now available to make your wrist beautiful. You can choose from the wide variety of ugg boots sale by comparing lots of perfect and stunning pieces. These ugg boots sale uk would be nice investments for you in long term. These cheap ugg boots are brilliant and prove to be wonderful for you while it makes you stand out of the crowd.
<p>Canada goose jackets give every men a variety to choose from. canada goose jackets sale And this Canada goose jacket can be the classic ones in Canada goose series jackets. Quilted down jacket in navy Concealable hood zips into collar Two way zip Stripe quilted panels at shoulders and sides Felted logo patch and tricolor stripes at upper arm. moncler jackets cheap Zip pockets at waist ruched elastic snap tab sleeve cuffs Drawstring hem Tone on tone stitching. If you know anything about fashion or with a method, you can buy everything jeans and goose down coats.</p>
<p>Helplessly watched the light on his brow, Mu Chen is unable to escape, when white light from him and a scale far when, he saw, flying is augg boots sale previous hit him in the shoulder in the heart of the stone as like as two peas. Iugg boots clearancen the face of the flying stones, he helpless eyes closed.</p>
I just required some information and was searching on Google for it. I visited each page that
came on first page and didn’t got any relevant result then I thought to check out the second one
and got your blog. This is what I wanted!
GHD
GHD straightener
Cheap ghd
GHD australia
GHD hair straightener
cheap ghd straightener
ghd boho
ghd glamour
ghd wave
ghd deluxe midnight
ghd pink
ghd leopard
Blue Serenity GHD
ghd dark
ghd kiss
mini straightener
With thunder two years and $6.5 million contract renewal
8. With thunder two years and $6.5 million contract renewal of KuiAn-cook. Cook in 2007 the first round of the 76 draft night 21 people team selected,cheap nike air max,
cheap nike air max 24/7,
nike shoes outlet,
cheap nike air max 90,
cheap nike air max 2012,
cheap nike air max shoes the four seasons has played in the heat and thunder. In the 222 games, cook averaging can get 7.5 points and 2.3 rebounds. On behalf of his team last season thunder 43 games,Wholesale nba Jerseys,cheap nhl Jerseys,Wholesale NFL Jerseys , NBA Jerseys,cheap mlb jerseys, NFL Throwback Jerseys,cheap nfl Jerseys,cheap NBA Jerseys cook all present 13.9 minutes with the can get 5.6 points and 1.7 rebounds, his 3-point shot 42.2%. And the three points is the lack of the thunder,cheap air max,
cheap air max shoes,
cheap jordan shoes,
cheap air max 90,
nike air max 2012,
air max shoes this is also out of contract he thunder decided to reason.cheap nfl jerseys,
cheap nhl jerseys,
football jerseys,
nfl football jerseys,
cheap nfl football jerseys,
cheap mlb jerseys,
cheap nba jerseys,
nfl jerseys cheap,
wholesale nfl jerseys
9.76 people team this summer signing first cheap nba shoes rookie nicola-wu's cut and second round picks pull walter Iraq Allen. Wu's cut from nba basketball jerseys,
cheap nba basketball shoes,
nba jerseys,
cheap nba shoes,
cheap NBA Throwback Jerseys,cheap nba jerseys the university of southern California, he in the first round of the 16 th overall 76 team selected, and walter Iraq is in total 50 overall pick.Green Bay Packers NFL Jerseys,
San Francisco 49ers NFL Jerseys,
Baltimore Ravens NFL Jerseys,
New Orleans Saints NFL Jerseys,
Pittsburgh Steelers NFL Jerseys,
New York Giants NFL Jerseys,
New England Patriots NFL Jerseys,
New York Jets NFL Jerseys,Cheap nfl jerseys,
nfl jerseys,
cheap mlb jerseys,nfl jerseys from china,cheap nhl jerseys,wholesale nfl jerseys,nfl jerseys cheap In addition, 76 people and free player Antonio Anderson, dwyane-Jones,wholesale authentic jerseys,
cheap authentic jerseys,cheap nhl jerseys,
wholesale authentic nfl jerseys,cheap mlb jerseys,
cheap authentic nfl jerseys.
Green Bay Packers NFL Jerseys
San Francisco 49ers NFL Jerseys
Baltimore Ravens NFL Jerseys
New Orleans Saints NFL Jerseys
Pittsburgh Steelers NFL Jerseys
New York Giants NFL Jerseys
New England Patriots NFL Jerseys mike-of Atlantis, and Xavier-sheila, so that 76 people of the book's list to reach 15 people.Herve Leger,
Herve Leger on sale,
authentic Herve Leger,
wholesale Herve Leger,
cheap Herve Leger,
Herve Leger Dress
I think Every women have Good Clothing seance, not only Cloth but Shoes are play important role in women dressing. Women go crazy for shoes trying to keep up with the latest fashion trends. Wholesale women's shoes cater for this demand and keep up with modern fashion trends in order to meet the demands by women.
It is good to read your post. I thank you to help making
people more aware of possible issues. Great stuff as usual. Thanks a lot for enjoying this beauty article with me. I am apreciating it very much! Looking forward to another great article. Good luck to the author! all the best!
This article was written well, is a very good article,
every article has their own characteristics, provide
different information, which for some people is very
important that each people put their own important
information to us, so we will a lot of information
for our study and reference, let us progress faster,
this is a good thing.
This article was written well, is a very good article,
every article has their own characteristics, provide
different information, which for some people is very
important that each people put their own important
information to us, so we will a lot of information
for our study and reference, let us progress faster,
this is a good thing.