Hi,

I created an SSRS report (main report) that contains three sub report(composed of ALL, Phone, Non-Phone and ). the main report has a parameter that choose a business unit (ALL, Phone, non -Phone). Basically my requirements, if i choose Business unit that contains "ALL" the subreport for 'ALL' should be the one to perform. If i choose Phone then it will perform the subreport for phone.

I also added parameter for business unit in every subreport that link to the main report. May i ask your help if this requirements is workable. When i run the main report and i choose "ALL" in  business unit the result the subreport displayed is for phone.

ny help is very much appreciated. thanks.

• Edited by Lenoj 2 hours 21 minutes ago

Hi ,

You have parameter option during binding of subreport.

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD#4

Thanks

Thanks for reply. I already perform this option adding the BU as Business Unit with an Option for ALL, Phone, and Non-Phone. Let say I choose the phone bad it displayed the All.

--Main SSRS with Business Unit parameter

--three subreport.

do i need to set a parameter for individual subreport? this is only my though because the parameter in subreport is like this [@BU], how this can identify the subreport that related to the selected BU. Basically the user will select parameter for Business unit values in main report and get the corresponding subreport related to the Business Unit that the user was selected.

• Edited by Lenoj 35 minutes ago

You Need BU Parameter in Both the Reports.

in Sub report you have to create BU parameter .

Please refer below image in which I have bind Martailstatus parameter in Sub report.
and same in main report I have also I Martailstatus