Matrix

I've produce a report using a matrix.

Within that matrix I want to navigate to a subreport, however this only applies to certain columns in the matrix and within only when a cell contains a certain value.

Can anybody tell me how to reference individual matrix columns and whether the above is possible?

It sounds like you want a "drillthrough" to another report rather than a subreport.

You can use an expression to dynamically determine the drillthrough target report name, e.g. based on a value in the matrix cell or based on a certain grouping scope. For instance, add a drillthrough navigation action on a matrix cell with an expression-based drillthrough report name: =iif(InScope("Matrix_ColumnGroupName"), "DrillthroughReportName", Nothing)

If the expression for the report name evaluates to Nothing, no drillthrough link will be shown.

-- Robert