pass multiple values as parameters from main report to drill down in SSRS
Posted on 2008-06-09
Hi, I am successfully able to set report parameters and use them in the data parameters on a main report I want to pass all the values now to the drilldown report. I went to the properties of the textfield, selected Navigate to the next report using the same parameters. It works but for only one of the multi values. I do not know how to test the string that is being passed in the SQL to see what is happening. Is it possible in the first place to pass multiple values to a drilldown report? I am using the same string as in the first report, in it's own query. I get the message that The report parameter "AcqID" has a DefaultValue or ValidValue that depends on the report parameter "AcqID"
Forward dependancies are not vailid.
WHERE ((C.AcquisitionID IN(@AcquisitionID)) AND (C.ResultID IN(@ResultID)) )