Hi, I have searched the forum but I can't seem to pinpoint the answer I need :(. I have a report in SSRS 2008 which is a table (tablix) report which comes from a SQL dataset. The dataset basically simply lists contact reference numbers against a subject name. i.e. the raw data list would be Subject Contact Ref Fencing 70341 Grass 70348 Fencing 70000 Grass 54856 so on and so on. The tablix report is grouped by subject and the first column is a summary (Total Contacts) i.e. =COUNT(Fields!Contact_Ref.Value) therefore the report to the user looks like this Subject Total Contact Refs Fencing 34 Grass 55 Trees 12 so on and so on. I want the user to click on the totals, i.e. 34 to a drill-down report which will show all the details of all the contacts that make up that 34. The drill-down report’s parameter for Contact_Refs is set to allow multiple values. I therefore need to pass the contact refs from one report to the drill-down and I am using =JOIN(SPLIT(Fields!Contact_Ref.Value, ", "), ", ") in the action area for the total cell in the first report which doesn't work as it is only passing the first contact ref to the drill-down report. Can you help please? Cheers Jon

Hi, If you want to show all the contac ref numbers of the selected 'SUBJECT', you can accomplish that by following steps: 1) Add a hidden parameter in the drill through report 'Subject' and make it hidden 2) Add a where clause in your drill through report query like 'Where table.columnname=@Subject' (if the contact details are in another table, you can use a join to fetch them) 3) In the 'Action' pass 'Fields!Subject.Value' to the drill through report. This should do.MSBI Developer

Yep it's 100% official, my brain is so mashed I didn't think that this could be done so easily by doing it this way. Cheers for the reply and it works. Out of interest, is there a way to pass the multivalues? :)

Hi, You can pass the multi values selected from a Multi value Parameter using Join(), but not the values from Fields.(Table cells).MSBI Developer

Cheers - understand what you mean.