I have been looking at creating drill through reports in report builder 2.0 and have managed to succesfully set up one based on a parameter. I would like the drill through to go to more than one report. What is the best way to set this up? Both of the drill through reports have the same parameter. Thanks

If you want to drill through to multiple reports, you can develop a condition as IIF(Parameters!Param.Value=0,"ReportA","ReportB") Let me know if this is not what you were looking for

Hi , Check the link below for multiple drill through http://www.sqlserverbiblog.com/CommentView,guid,4722e3ec-ca0e-4e1b-91c6-3c9ae1c4e973.aspx Regards, PSRegards, PS

on the conditional expression that I posted =IIF(Parameters!Param.Value=0,"ReportA","ReportB") 'Param' should be the parameter you use in your report to navigate to what ever reports you want to navigate to. (in this case, it was just example - param(your parameter) and ReportA(name of the report to navigate to) Hi I did think that is what you were getting at so I have tried the following IIF(Parameters!merchantname.Value=0,"reporta","reportb") but I still get a error message The DrillthroughReportName for the text box ‘merchantname’ is not valid. Item names cannot contain the following reserved characters ;?:@&=+$,\*<>|". (rsInvalidReportNameCharacters) when I have used the drill through on just one report I have selected the browse and select the report on the sharepoint server that I want to drill through to. eg /DWH Risk/reporta and then I have added the parameter merchantname in the Text Box properties Action. Not sure where I am going wrong

If you want to drill through to multiple reports, you can develop a condition as IIF(Parameters!Param.Value=0,"ReportA","ReportB") Let me know if this is not what you were looking for Hi I have tried this and I get the following error message The DrillthroughReportName expression for the text box ‘merchantname’ refers to a non-existing report parameter ‘param’. (rsParameterReference) I am still looking through the other suggestion made

on the conditional expression that I posted =IIF(Parameters!Param.Value=0,"ReportA","ReportB") 'Param' should be the parameter you use in your report to navigate to what ever reports you want to navigate to. (in this case, it was just example - param(your parameter) and ReportA(name of the report to navigate to)

Hi, First, please make sure both reports specified in the expression exist on the Report Server. Besides that, I also noticed that you have configured the Report Server in SharePoint integrated mode. When click the Browse button and select one report, report name is added with its path. So, please also type in the path with the report name in the expression. For example, =IIF(Parameters!merchantname.Value=0,"/DWH Risk/ReportA ","/DWH Risk/ReportB"), and then test again. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.