Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Reporting Services 2008 R2 Data Bars

Last week I wrote a blog explaining how the new tool inside Reporting Services 2008 R2 called Indicator will be help for displaying KPIs in Reporting Services.  Today I want to looks at another nice feature added to Reporting Services in R2 called Data Bar.  It’s a small but nice add to the product that gives it a little bit of an Excel look and feel. 

You may already know there is a nice but simply feature in Excel to help you compare data called Data Bars shown below, shown below.

 

This same functionality with even the same name has been added to Reporting Services.  It works just like any chart that you may have used in the past.  Drag it into a cell of a table then tell it what value you want represented on the bars.  Data Bars do not work on the detail level group so you may receive an error if you try and add one there.  You can add a label to the bars so you know what values are represented however it seems that the property to change the alignment of the label does not work properly yet, see below.  Hopefully this will be fixed when the product is officially released.

 

Comments

Posted by Anonymous on 12 April 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, Reporting Services 2008 R2 Data Bars - Devin Knight         [sqlservercentral.com]        on Topsy.com

Posted by Anonymous on 13 April 2010

Pingback from  teched 2008: Demonstration of SQL Server 2008

Posted by Anonymous on 21 May 2010

Pingback from  D200 Discount Lens Nikon, Rd200 Definition

Posted by Anonymous on 21 May 2010

Pingback from  G1000 Episodes Discount Graphite, Gmc G1000 Season Aftermarket

Posted by Anonymous on 21 May 2010

Pingback from  E325 Part Raptor E550, 325e Treatment Discount

Posted by Anonymous on 22 May 2010

Pingback from  1971 Vw Squareback German, Squareback New 1973 Volkswagen

Posted by Anonymous on 22 May 2010

Pingback from  Typhoon Blood, Cladding Syclone Typhoon

Posted by Anonymous on 22 May 2010

Pingback from  K 10 Chevrolet K10 For Sale, K10 Pickup Discount Silverado 2500 S10 Blazer

Posted by Anonymous on 25 May 2010

Pingback from  Bmw 325i Gebrauchtwagen, 2003 Bmw 325i 4 Door Sedan - 313.luna-atra.net

Posted by Anonymous on 25 May 2010

Pingback from  1200 Promo Classifies, 2007fp 1600x1200 - 46.codebluehacks.org

Posted by Anonymous on 25 May 2010

Pingback from  Handleiding Nikon D200, D200 2500 Radiator - 109.mfbattle.com

Posted by Anonymous on 25 May 2010

Pingback from  Toyota 2009 Prius, Toyota Prius Rent - 220.ja3ra.com

Posted by Anonymous on 25 May 2010

Pingback from  1970 Vw Karmann Ghia Video, Bargain Volkswagen Karmann Ghia - 437.animejin.com

Posted by Anonymous on 25 May 2010

Pingback from  P40 K1500 Pickup Headlight Dimmer Switch, K1500 Suburban Part Cylinder Head Gasket - 374.cmanager.org

Posted by Anonymous on 25 May 2010

Pingback from  Maserati Cape Town, Queenstown Factory - 14.myipgirl.com

Posted by Anonymous on 25 May 2010

Pingback from  P25 P2500 Van Installation Fits, P35 P2500 Van Replacement Acdelco - 303.mfbattle.com

Posted by Anonymous on 25 May 2010

Pingback from  Auto Mieten Montego Bay, Headlight Tail Light 1973 Mercury Montego Side Marker - 430.unlockiphone30.net

Posted by Anonymous on 25 May 2010

Pingback from  250sl Vintage 1960s, Dell Optiplex 960 Linux - 126.unlockiphone30.net

Posted by Anonymous on 25 May 2010

Pingback from  Dodge 1500 Truck Beds, 2008 Super Duty Prices Ford F 150 - 230.akemet.com

Posted by Anonymous on 25 May 2010

Pingback from  Cold His Shadow, Shadow Furnace Creek - 393.unlockiphone30.net

Posted by Anonymous on 25 May 2010

Pingback from  98 Mazda B2500 Dome Light, B2500 Center - 6.eumreborn.com

Posted by Anonymous on 25 May 2010

Pingback from  Elantra For Sale Buy Used Generation, 2001 2006 Hyundai Elantra Radiator Plastic Tanks - 342.myipgirl.com

Posted by Anonymous on 25 May 2010

Pingback from  Atlanta Omni Centennial Olympic Park, Omni Coolant Engine - 18.defutbolazo.com

Posted by Anonymous on 25 May 2010

Pingback from  Dodge Caliber Body Kit Cold Air Intake, Caliber Bumper Dodge Neon - 293.tvshowzone.com

Posted by Anonymous on 25 May 2010

Pingback from  Used Saturn Ion 3 Quad Coupe Chili Pepper Edmark Superstore, 3500 Hd Chevrolet Silverado 3200hd Work Truck - 449.cmanager.org

Posted by Anonymous on 25 May 2010

Pingback from  Ford Probe Exhaust System Pacesetter, Change Fuel Pump 95 Ford Probe - 66.luna-atra.net

Posted by Anonymous on 25 May 2010

Pingback from  735i Passenger Moe Replacement, 330i Parts 735i Bmw 535i - 318.computeronlinebingo.com

Posted by Anonymous on 25 May 2010

Pingback from  Jeep Grand Wagoneer Trim Parts Roof Rack, Legacy Audio Grand Marquis Speaker - 398.tvshowzone.com

Posted by Anonymous on 25 May 2010

Pingback from  760i Globe New Bmw, Volvo 760 Headlight Turn Signal Brake Rotors - 297.rkwrh.com

Posted by Anonymous on 25 May 2010

Pingback from  Fog Light Plymouth Pb300 Car, Pb300 Ford Bumper - 204.akemet.com

Posted by Anonymous on 25 May 2010

Pingback from  330xi Factory Awd, 330xi Decor Front - 397.unlockiphone30.net

Posted by Anonymous on 27 May 2010

Pingback from  1999 - 1988 @ 1979 Pontiac Firebird Grill, 1991 Firebird Mods - 192.an74.com

Posted by Anonymous on 27 May 2010

Pingback from  1987 - 1994 @ Heater 2000 Volvo S70 Brake Dust Shields, S70 Trim - 154.rkwrh.com

Leave a Comment

Please register or log in to leave a comment.