{"id":4567,"date":"2024-02-29T15:27:52","date_gmt":"2024-02-29T15:27:52","guid":{"rendered":"https:\/\/himbap.com\/blog\/?p=4567"},"modified":"2024-02-29T15:27:52","modified_gmt":"2024-02-29T15:27:52","slug":"hiding-subreport-text-box-in-main-report","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=4567","title":{"rendered":"Hiding Subreport Text box in Main Report"},"content":{"rendered":"

Requirement<\/strong>
\nAs a SQL Server Reporting Services (SSRS) developer, you often encounter scenarios where you need to customize the visibility of elements like text boxes within subreports based on certain parameters. This kind of dynamic behavior enhances the user experience and ensures that reports are tailored to specific requirements. In this blog post, we’ll explore how to hide a textbox within a subreport based on parameter.<\/p>\n

Understanding the Scenario<\/strong>
\nLet’s imagine a scenario where you have two reports, subreport and main report. There is a text box on the subreport which we only want to show when rendered in the subreport but while this subreport is used in the main report we want to hide this text box, let see how we can do that using parameter.
\nYou can see in the below screenshot I have two report SubReport and MainReport, In the SubReport I have added a text box I want to hide this when this will render in the main report.
\n\"SSRS1\"<\/a><\/p>\n

I have added SubReport to main report like below<\/p>\n

\"SSRS2\"<\/a><\/p>\n

Now when we will run our MainReport, we will see the text box we added in the sub report like below:
\n\"SSRS5\"<\/a><\/p>\n

Now in order to hide text box in the SubReport, let’s add a parameter named ReportName in both the report and we will keep this parameter hidden as we are going to set default value to this parameter.
\n\"SSRS3\"<\/a><\/p>\n

Now we need to set default value as name of the report so for example in the main report parameter value will be “MainReport”<\/p>\n

\"SSRS4v1\"<\/a><\/p>\n

Finally to hide this text box, we need to following two steps:
\nAdd Expression to text box<\/strong>
\nIn the SubReport, we need to edit text box properties and add expression to hide show text box like below:
\n\"SSRS6\"<\/a><\/p>\n

Above expression will checking value of the parameter and based on that it will hide\/show text box.
\nPass Parameter to SubReport<\/strong>
\nNow we need to pass ReportName parameter from Main report to Subreport like below:
\n\"SSRS7\"<\/a><\/p>\n

Now when we will run our MainReport, we won’t see text box anymore<\/p>\n

Summary<\/strong>
\nWe learned how to utilize parameter in SSRS to hide\/show text box. By following the steps outlined in this blog post you can effectively control the visibility of elements within SubReports using parameter, enhancing the usability and effectiveness of your SSRS reports.<\/p>\n

Hope it will help someone !!
\nKeep learning and Keep Sharing !!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Requirement As a SQL Server Reporting Services (SSRS) developer, you often encounter scenarios where you need to customize the visibility of elements like text boxes within subreports based on certain parameters. This kind of dynamic behavior enhances the user experience and ensures that reports are tailored to specific requirements. In this blog post, we’ll explore how to hide a textbox… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":4597,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[862,1081,1079,1080,1078],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4567"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4567"}],"version-history":[{"count":7,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4567\/revisions"}],"predecessor-version":[{"id":4601,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4567\/revisions\/4601"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/4597"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}