At the moment, I'm creating some complex tables in Reporting services (2005).
In fact, the only two tables you can have are vertical tables and matrix tables. It is possible to create a horizontal table, but you have to rework a matrix to get to it.
The table I'm currently building in Reporting services involves nesting a vertical table inside a matrix.
As it seems, the table works fine, it exports well to pdf -- but excel won't work. It seems to be impossible to export complex nested tables to Excel.