http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspxThis is my first post in what I hope is a long series of how to's related to data visualization. For my first post I'm going to demonstrate how you can add sparklines to your SSRS reports. Below is a screenshot of what a sparkline may look like inen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#10259258Sat, 21 Jan 2012 18:00:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:10259258jim<p>figured it out. &nbsp;I was returning 0 in my function, &nbsp;changed it to system.dbnull</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10259258" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#10259257Sat, 21 Jan 2012 17:57:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:10259257Jim<p>I am using sparkings on a column of data that has nulls &nbsp; The default behaviour shows the nulls as zeros . &nbsp;How can I show the chart with a gap for nulls?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10259257" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#10237107Tue, 15 Nov 2011 04:00:41 GMT91d46819-8472-40ad-a661-2c78acb4018c:10237107Samuel Vanga<p>Very useful post! I had to use two data points and apply conditional formatting. </p> <p>Documented it &lt;a href=&quot;<a rel="nofollow" target="_new" href="http://svangasql.wordpress.com/2011/11/14/how-to-add-sparkline-in-ssrs/&quot;&gt;here&lt;/a&gt;">svangasql.wordpress.com/.../a&gt;</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10237107" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#9021622Wed, 29 Oct 2008 07:30:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:9021622Robert Bruckner's Advanced Reporting Services Blog<p>My colleagues Sean Boon and Alex Gorev recently started their own blogs with focus on data visualization.</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9021622" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#9020332Tue, 28 Oct 2008 18:14:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:9020332kevinjgoff<p>The new charting features are great. &nbsp;This one in particular is very useful for us. &nbsp;Thanks!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9020332" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#9018685Mon, 27 Oct 2008 21:02:38 GMT91d46819-8472-40ad-a661-2c78acb4018c:9018685sfblackl<p>Sean - I'm having the same issues as tlhacker (detail member with inner members). &nbsp;I can put the sparkline on the grouping row (geo), but not on my detail rows (country). &nbsp;</p> <p>If it isn't supported, would just love to know that so that I don't go hitting my head and trying different ways to work around. :)</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9018685" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#9014239Fri, 24 Oct 2008 09:13:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:9014239Andrew Wiles<p>Folk working with SQL Server Analysis Services might be interested in a new set of custom functions for SparkLines and other high density charts released by iT-Workplace.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9014239" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#9013414Thu, 23 Oct 2008 20:56:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:9013414tlhacker<p>Sean,</p> <p>The creation of the chart and embedding the chart in the tablix worked fine as described, but when I preview it, I get the following error:</p> <p>[rsInvalidDetailDataGrouping] The chart ‘Chart1’ has a detail member with inner members. Detail members can only contain static inner members.</p> <p>I'm using RS2008/VS2008 by the way. If I remove the grouping on the detail row, the report will render, but of course I lose my grouping. &nbsp;Any ideas?</p> <p>...and thanks for the post on this topic.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9013414" width="1" height="1">http://blogs.msdn.com/b/seanboon/archive/2008/10/10/how-to-build-sparkline-reports-in-sql-server-reporting-services.aspx#8993760Fri, 10 Oct 2008 08:40:25 GMT91d46819-8472-40ad-a661-2c78acb4018c:8993760 How To: Build Sparkline Reports in SQL Server Reporting Services : EasyCoded<p>PingBack from <a rel="nofollow" target="_new" href="http://www.easycoded.com/how-to-build-sparkline-reports-in-sql-server-reporting-services/">http://www.easycoded.com/how-to-build-sparkline-reports-in-sql-server-reporting-services/</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=8993760" width="1" height="1">