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.
I've just stumbled upon an odd issue with the Tablix control in SSRS 2008. I deployed a report on a server a few weeks ago and it is now reporting on enough data to make it span multiple pages. I wanted the column headings to appear on all pages, not just the first. However, when I set the RepeatColumnHeaders property on the Tablix to be true, the headings still did not appear on the next page.
In Reporting Services, formatting dates can become a headache for the developer, often due to differing regional settings on servers, development boxes etc. Therefore I've found it much more useful to force the report to use a particular format, rather than allow the server settings to decide for me. Previously I would have used FormatDateTime in the expression, as shown here:
=FormatDateTime(Fields!DateStamp.Value, DateFormat.ShortDate)
Depending on the regional settings, this could return either 12/3/2008 or 3/12/2008.