posted on Monday, July 26, 2004 3:04 PM
by
thomasswilliams
Pivot Tables/Horizontal Tables With Reporting Services
Chris Hays shows step-by-step how to do “horizonal tables” (fixed rows, variable columns) with Reporting Services. I'm bookmarking this to have a look at later.
Chris uses the matrix which is an interesting Reporting Services control. I've used this in the past to take advantage of the multi-level drill-down which I reckon is slightly easier to use than a table control. The subtotals are easier than tables too, but there's a trade-off because with the table you have very tight control over what gets displayed, and how, compared to the matrix.