Share via

How to Set visibility between subreport and Textbox

Santosh V 116 Reputation points
Oct 31, 2020, 3:15 PM

36563-capture.png

I have below requirement

  1. By default need to set visibility = false (Sub Report)
  2. When i click on Sprint Name (text box from the main report) then need to set visibility = true for sub report

please help me to achieve this

Regards
Santosh

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,944 questions
0 comments No comments
{count} votes

1 answer

Sort by: Newest
  1. ZoeHui-MSFT 38,066 Reputation points
    Nov 2, 2020, 6:07 AM

    Hi @Santosh V ,

    If you want to set visibility between subreport and main report's textbox.

    The subreport should be in the same scope with the textbox.

    Add the subreport to the main report and set the visibility to "hide" and "display can be toggled by the report item"

    36660-screenshot-2020-11-02-135244.jpg

    In this situation, the report needs some changes of the appearance. Which means if you want the outlook like the image you shown, it's impossible.

    You may also set the action of the textbox and set "go to report".

    When you click the textbox, it will go to the subreport you set.

    Regards,

    Zoe
    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October:
    https://learn.microsoft.com/en-us/answers/questions/142427/users-always-get-connection-timeout-problem-when-u.html


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.