Hi all, I got a big performance problem on my one report.In my report there is one group in which embedded one sub report.I found that when reporting service loaded the main report,it also would load the subreport. By the way,in my report by default,the subreport will be hid,at the same time i set the subreport toggled by the group textbox.My reqiurement is i want reporting service to load subreport when i toggle the group textbox to indicate the subreport to display.Unfortunately,until now i've not found any way to achieve that.I do know if you guys know how,any reply would be appreciated. Thanks aaron

Hi, You don't want subreport run when it is hidden, right? The Visibility property only changes the view of the report not rendering. Even you set it to be hidden, it should render on backgound. Thanks.Yao Jie Tang -Microsoft Online Community

yes, so the first time that the ssrs load the report,it will call all data include main report and subreport ,so it will cause a performance problem.aaron

So, you could set a parameter for subreport along with visibility condition. If the subreport shown, the parameter will be a proper value for it. If the subreport hidden, the parameter will be a invalid value for it. This will let the subreport returns more quickly. Thanks.Yao Jie Tang -Microsoft Online Community

This is a great tip. After searching days for a solution I found this. Thanks !!!! Reporting Services has still a long way to go before it has the same functionality as with Access Reports. I can not understand that they have drill down reports but in the background it renders everything.

Hi folks, I am a beginner in SSRS. Where would you setup the correct value for the parameter? At the moment, all I use is the property Visible/Hidden = "true" and Visibility/ToggleItem = "my text field" How can I set a parameter at the moment the user toggles this item and how would I refresh the sub-report? Thanks EricEric Mamet _ MCDBA, SQL Server 2005 MCTS, MCAD .Net