In SSRS, how do I change the text in a textbox based on the visability toggle status?

Posted on 2009-02-10
Last Modified: 2012-05-06
I am using a text box as the toggle switch to show and hide a graph held in a rectangle control. The text in this box states "Open Graph". When I click on the [ + ] and the graph is revealed  I want the text box  to say "Close Graph".

Can this be done?
Question by:PSTCAT
    LVL 21

    Accepted Solution

    unfortunately, the Reporting Services are not even-driven and that's what you want in this case. After report was rendered, it's pretty much static HTML and not interactive like applications.

    I was going to offer you a work around, but checked it and it didn't work. The idea was having two textboxes one on the top of each other and have their visibility toggled by each other as well. So if one is visible (Show Graph) the other one is hidden (Hide Graph) and vice versa. Unfortunately, it didn't work as if you set one of them to be hidden, the other one is not shown either even if hidden is set to false.

    So, to avoid confusion, I'd probably have a parameter instead of a texbox with two values: Show Graph, Hide Graph. And I would toggle visibility of the graph based on the parameter value.


    Author Closing Comment

    Many thanks Yurich.
    In the end I did away with the idea and just gave it a title. But I will have ago at the parameters idea later.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now