SSRS Text box expression based on the condition

kkran 831 Reputation points

Hi team - I have two text boxes in SSRS Report.
In Textbox1: there is a field1 that will be displayed. The field1 value will change depending on the multiple scenarios.

The textbox2 should be dependent on Textbox1.

If the Field1 in Textbox1 has values of either 'Income high' or 'Income low' then only the textbox2 should be displayed. If not, no need to display the textbox2.

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,849 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points

    Hi @kkran
    I did some tests locally.
    The expression to set the visibility of textbox 1 is as follows:

    =IIF(First(Fields!field1.Value, "DataSet1")="Income high" or First(Fields!field1.Value, "DataSet1")="Income low",True,False)  

    The expression to set the visibility of textbox 2 is as follows:

    =IIF(ReportItems!Textbox1.Value="Income high" or ReportItems!Textbox1.Value="Income low",False,True)  


    For the ReportItems collection references, please refer to: Built-in collections - ReportItems collection references in a paginated report (Report Builder).

    In order to show the variability of textbox 1, I set a parameter with three values: "Income high", "Income low", "Unknow", my purpose is when textbox 1 displays "Income high" or When "Income low", text box 1 is hidden and only text box 2 is displayed; when there is no "Income high" or "Income low" in the text box, that is, "Unknow", text box 1 is displayed and text box 2 is hidden.
    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful