Problem Unhiding Parameter Drop-down Menus From Subreport  in Report Manager 2008 R2
Hello All, I am using a drop-down box in a report so the user can select a parameter. Once the "View Report" button is clicked and the report refreshed, the user has the option of clicking a button (really a textbox made to look like a button) to open a subreport. The parameter selected in the previous report is passed to this subreport. This functionality all works fine, but the problem i'm having is that when the subreport opens, the parameter drop-down boxes are hidden in Report Manager. This is a problem because in RS 2008 R2, the button to unhide the drop-down boxes is hard to see and not intuitive to end users. I would like to know if there is a way to tell Report Manager NOT to hide the drop-down boxes. The weird thing i've noticed is that when I use the URL option to open the report instead of using the subreport option (under ACTION on the textbox/button), the parameter drop-down menus are not hidden. Only when using the subreport option does it remain hidden. I have a rather large project and so using URLs will be tricky and not very easy to maintain. Can anyone tell me how to prevent the parameter drop-down boxes from being hidden in Report Manager?
October 15th, 2010 4:05am

Hi AvenueStuart, By design, in SQL Server Reporting Services(SSRS) 2008 R2, the SSRS will hide the parameter panel to expand the display area for the report rendering. I know you may have a concern that the 'Show / Hide parameter' button is too small to be seen. For this concern, I would suggest you submitting a feedback at https://connect.microsoft.com/sqlserver. Anyway, I implemented a workaround. However, please note it is not tested, and it is not recommended to be used in product environment: Open the 'Report.aspx' with text editor. The 'Report.aspx' can be found from C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\Pages by default. Add the following script to the end of the file: <script language = "Javascript"> function SetToggleParamImg() { dueTime += 50; if(dueTime > 3000) { clearTimeout(timer); return; } var obj=document.getElementsByTagName("INPUT"); var obj2 = document.getElementById('ctl31_ToggleParam'); for(var i=0;i<obj.length;i++) { if (obj[i].type=="image" && obj[i].title=="Show / Hide Parameters") { clearTimeout(timer); obj[i].style.height = "12px"; obj[i].parentNode.parentNode.parentNode.style.height = "12px"; return; } } timer=setTimeout(SetToggleParamImg,50); } var dueTime=0 var timer; timer=setTimeout(SetToggleParamImg,50); </script> Save the file. Now, the image is 12px height. It is a bit bigger than the original one. It is easy to see now. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 10:54am

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

Other recent topics Other recent topics