Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Table Below Graph Expand / Collapse
Author
Message
Posted Monday, April 23, 2012 6:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:04 AM
Points: 115, Visits: 1,010
Does anyone know if it's possible within Reporting Services 2008 R2 to automatically display a data-table below the graph like you can within Excel or do you have to create a tablix?
Post #1288594
Posted Tuesday, April 24, 2012 9:37 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:18 AM
Points: 162, Visits: 836
I think you have to create a table/matrix outside the graph itself, however, there are some neat ways of making it correspond to the chart (like a legend) and even making it interactive at these links:

Custom chart legend:
http://blogs.msdn.com/b/bwelcker/archive/2005/05/20/perfect-from-now-on-custom-chart-legends.aspx

Add a data table (ctrl+f for Adding Chart Data Tables):
http://msdn.microsoft.com/en-us/library/aa964128(v=sql.90).aspx#moressrscharts_topic4
Post #1289104
Posted Tuesday, October 30, 2012 7:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 5:42 AM
Points: 32, Visits: 130
Follow this blog post

http://road-blogs.blogspot.com/2012/10/ssrs-charts-with-data-tables-excel-style.html

You can download the report file at the end of the post :)
Post #1378784
Posted Tuesday, October 30, 2012 8:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:18 AM
Points: 162, Visits: 836
That's a good article - I was admiring it this morning on linkedin
Post #1378793
Posted Tuesday, October 30, 2012 8:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 5:42 AM
Points: 32, Visits: 130
Thanks Steph :)
Post #1378796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse