Detail header and footer of Report Services Documents can be set to be rendered horizontally. When this option is used, grids can be placed side by side without overlapping each other:
- Create a report with Year in the rows, and Month in the columns. Add an attribute element prompt on Month.
- Create another report with Year in the rows, and Revenue in the columns.
- Create a document using these two reports as datasets.