Graph(Chart) showing data

Hot Topic

Getting Started
SQL Server 2005 and SSPI Context on XP
Suppress Text Wrap
Export to Excel - "Convert from Number to text" to Number
Another question about Login failed, but with Windows NT Integrated security for SQL 2005
Limitation for UDAs
Question on Integration of SSRS 2005 Graphs into Sharepoint
SQL Server 2005 Remote Connection
SQL Server 2000 and SQL Server 2005 have the different behavior
Null key field in Oracle EBusiness Suite

SQL Server

Column Sorting
Complex XML Parsing/Shredding
Newbie question - how do I specify a variable for the file location when using the Execute Package Task
Newbie: what kind of "cube" is this?
Multiple details sections, possible?
No Real in 2005??[:S]
cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer
SQL 2005 and SQL 2000, one Dev server, co-existence
Linked Server
SSIS error listing

Graph(Chart) showing data

Hello

I am making the switch from using MSACCESS to do required reporting to using Reporting Services to accomplish the same tasks.

A requirment I have is that whenever a graph (chart) is created, it contain the underlying data in a connected and aligned data table. MSACCESS allows this by selecting the chart options and then "show data table".

Is this ability included in Reporting Services in MS Visual Studio 2003 .NET If so, how can I enable it I currently can only enable the legend.

Currently we are using:

  • SQL Server 2000 (sp3a)
  • Reporting Services (sp2)
  • Visual Studio .NET 2003

Thanks for any and all help.

Ben

Answer this question

Graph(Chart) showing data

  • skud13

    unfortunately that doesn't help me since we only have SQL server 2000 here at work.

    Ill keep my fingers crossed for another service pack that includes basic functionality...(like SP2 did with being able to directly print a report....)

    Ben

  • NuclearIntern

    Data tables are not directly supported. You would need to add a table data region (or a matrix if you have both, dynamic series groupings and dynamic category grouping in the chart).

    For the table/matrix you would use the same grouping expressions that are used in the chart.

    -- Robert



  • prabin dahal

    I can't be the only one who sees the value in having this option available

    Do you (or anyone) know if MS is planning to include this in an upcoming sevice pack/upgrade

    Thanks.

  • -Jazzy

    While data tables are not natively supported in RS 2005 at this point, you can get them as part of the chart through "Dundas Chart for Reporting Services" which installs on top of RS 2005.

    -- Robert



  • karefrey

    They are not part of Dundas. See link below. This is a BASIC feature of Excel. It's hard to fathom how the basic features of the chart object in excel haven't made it into reporting services. I would think alot of people are migrating reports from excel to RS.

    Does anyone know if this will be available in SSRS 2008 (i've posted similar question on Katmai reporting services forum but haven't got an answer.)

    http://support.dundas.com/forum/m.aspx m=4951&mpage=1&key=legend
  • Graph(Chart) showing data
Answer this question