Hi,

Ok so an update.

I've managed to do this using extra datasets.

So I have a Summary report and a Detailed report.

On the detailed report I have created a parameter and a dataset called "Location Status". The dataset only has one field in it.

In the parameter I set it to multiple values and also set the available and default values to "Get Values from a query" and pointed it at my dataset.

On the summary report I have a total number - that withing the tablix properties only shows a location status of occupied and void.

On the textbox I have set an action on it to open a report and at first I set the parameter I created in the detailed report to equal the location status. When you drill down you only get the occupied and not the void?

The only way I can get it to work is to have two parameters to run the report that uses the following fuctions -

= "Void"

and

= "Occupied"

Now when I click on my total it drills through correctly.

Is there any way to include the above in one parameter on the action instead of the two I have?