Cart data row

Hot Topic

Determining the most appropriate conversion for a string
Need help with Credentials.....
DTS & SQL Server Management Studio Express
MULTIPLE DATA SOURCES WITH SAME TABLE SCHEMAS IN SSIS
What credentials do I need to register a SQlServer2000 under SQL 2005 MMC
Can I Turn off Auto Execution of Report when all parameters have default values?
Poor performance when looping through table columns
Remote Connection problem on MS SQL 2000
Performing a range lookup using two tables
Redudant Data on a table column...

SQL Server

I need some information regarding Windows Mobile5.0
How to Update or Delete records with a SqlServer Destination
Management Studio Express CTP update now available
Timeout expires when deploying assemblies in SQL Server 2005 June CTP
Trigger changes do not Replicate (Merge Replication)
Buffer Exception
Sql query for helpdesk application
Poor performance when looping through table columns
Calculating % in Text Box
DB connection in a Script Transformation

Cart data row

I have a SQL table with summary data.  I want to display a pie chart for fields in each row and a table that displays values from the corresponding row.

I have a table and pie chart defined.  However the pie chart only displays for the first row in the table.  The table repeats ok for each row in the table.  I have tried placing a rectangle on the report and putting the chart and the table in the rectangle but it still works the same.  The table and pie chart use the same dataset.

I have read about nesting data regions but I cannot see how to make a link between the table and pie chart.

Answer this question

Cart data row

  • Tim Burton

    You need to add a grouping (on RowNumber() for example) to the chart in order to display each row in the dataset. The difference between chart and table is that table displays details when there's no group expressions, while chart also shows groups and aggregated data.

  • Cart data row
Answer this question