SSRS Drill Thru Report
I have a "summary" report which allows user to click on a textbox(cell in a column) to drill thru (open) a detail report and also pass on several pararmeters from the "summary" report to the drill thru detail report. Everything is working fine when doing it in a browser (IE7 or IE8). However one user complain the drill thru report does not work and she said that after opened the "summary" report in a browser and she would export it to an Excel and open the drill thru report by clcikng on a cell in Excel. I tested it and it is true, failed to open the drill thru report saying that "missing value on a parameter". However I did some digging into it and noticed that the drill thru report not working only if that parameter passing from the summary report contains of multiple values and the expression I used in the summary report for that field as a pass-thru parameter is as follow: However it works if that parameter consists of only a single value, it is working in Excel to open the drill thru report. There is no problem opening the drill thru in the browser regardless how many values in that parameters passing from the summary report. I also noticed the URL address to open the drill thru report from the Excel and it has "%2c" to seperate out the multiple values for that parameter. For example if the parameter has 2 values like "car" and "boat", it will have the string "parameter=car%2cboat" etc. Thanks Paul Kahlua "=Split(UCase(Fields!drug_csv_list.Value),", ")"
August 12th, 2011 2:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics