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.
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.
No comments:
Post a Comment