Troubleshooting

Adding an OLAP Grid to an Existing Report

I want to add an aggregated OLAP grid view to an existing drill-down report.

This can be quickly accomplished by accessing the Insert OLAP Grid functionality from the main Insert menu. An alternative approach that might make sense in certain situations is to insert a subreport that points to the involved OLAP datasource. Using a subreport to host the OLAP grid enables you to dynamically pass in parameters from the main report into the subreport and its associated OLAP grid. These parameters can be used to dynamically filter the columns, rows, and slices of the involved OLAP grid(s).