score:0

The problem is that you are using the [Status] field value to pass to the drill down report but the way you built your first report means that this will not be available.

You have 2 ways of fixing this I think.


The quick fix:

Simply change the Status parameter value from [Status] to a static text value that your drill down report will accept, such as Failed.


The longer but possibly better way...

Change the first report to be a Matrix,

Have a row group by Period and Column group by Status. This will save you having to setup specific expressions for each column. The other advantage is that if other Status value where added to the data in the future such as 'In progress', 'Cancelled' etc... then these would automatically appear in the report.

The drill down Action would then be setup exactly as you have done now (in your screen shot) and only needs to be setup once.


Obviously it's your decision but if it was me, I would spend the time getting this done properly


More questions

More questions with similar tag