SSRS switching between two textboxes: how to switch between 2 textboxes in SSRS 2008 R2

Question

hi,
Does anybody know how the visibility can be toggled between two textboxes in ssrs? For example if initially textbox1 is visible and textbox2 is hidden then,  clicking on textbox1 should make textbox2 visible and textbox1 should go invisible ... and then again when clicked on textbox2, should make textbox1 visible and textbox2 should go invisible.
In a short, it is like switching visibility between 2 textboxes... A click on first textbox should display the second textbox and another click on second textbox should display first textbox.
I cannot provide parameter as it is not there in the requirement.

It will be also very helpful even if somebody suggests how to toggle the text within a single textbox to achieve the above requirement...

Can anybody help me in this?

Answer 1

Hi There

Thanks for your posting. I think what you could do, create a hidden parameter and set the value when you click on textbox1 and textbox2. so please do the following

Create a parameter say hiddenPram with two values 0 and 1

Set the visibility of textbox based on the value of 0 and 1 so  when your hidden parameter have a value 0 then textbox1 will be hidden and textbox2 will be visible and when the value is 1 textbox2 will be hidden and textbox1 will be visible. Now when your User click on the textbox2 in the action tab pass value 1 to your parameter and refresh the same report again.

Now your parameter got value 1 and your textbox1 will be visible and textbox2 will be hidden.

I hope this will help

Many thanks

Syed Qazafi Anjum

Answer 2

Woww.. It worked... thanks a lot :) It solved 80% of the problem..

but a small issue in this is,

whenever i am setting action for the textbox, i am setting "Go to Reports" to the same report... , but then it shows page1 of the report.., where as my textbox1 and textbox2 are there in the page 2 and also the associated charts are present in page2 itself. I want whenever the user clicks on textbox1, it has to show textbox2 and the navigation has to remain in the same page i.e. page2.