Have you come across a scenario, where your pie chart shows the distributions of data based on a particular metric, say product, and over a period of time when the number of products increase, then the Pie Chart has to show all the products, which results in a very cluttered Pie Chart and makes it difficult to digest the information presented, leaving your chart in a non usable state. Having large number of categories means that the Pie contains a large number of slices (one per category) and as the number of slices grow, chart becomes less and less intuitive to the users and at some point, it gets into a state, where no one can use it to derive meaning conclusions. The problem that I am talking can be better explained using the below pie chart sample:
To deal with this kind of scenarios in a SQL Server Reporting Services (SSRS) report, there are different options which I will be discussing in this article. To get a more clear picture of the problem and the possible solutions, and to read the full story, follow this link: Handling a Large Number of Categories in a SQL Server Reporting Services Pie Chart.
- Tips ‘N’ Tricks – SSRS – Ensure Consistency across Multiple Reports using Report Templates
- Deploying Multiple Reports to Report Manager in One Go in SSRS
- Restricting Exporting Options in SQL Server Reporting Services (SSRS)
- Formatting Minutes as Hours and Minutes in SQL Server Reporting Services (SSRS)
- How to Display Report Execution Time in SQL Server Reporting Services (SSRS)
- Tips ‘N’ Tricks – Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills