charts

I found an interesting forum post over at SQLTeam this morning, and decided to have a go at coming up with a solution. Filters are quite commonly used in Tablix reports to show only the top n rows from a dataset. This is easily done by using the Top N operator in the Filters tab of the Tablix, and choosing the column in the Expression drop down. In the forum post however, the original poster was wanting to show the top n values in a chart.