Changing the text field depending on the choice of a logical parameter in SSRS

I have a report that contains two tables: one for a detailed report, and the other a summary report. I installed it where, if the Summary (boolean) parameter is set to true, you will only see the Pivot table table and vice versa if it is set to false. But I have a text box in the header that reads Report (Detail). I would like this text field to change depending on the same parameter, therefore, if the parameter of the final parameter is set to true, then the text field will read "Report" ("Summary"), and if it is set to "false" , he will read "Report" ("Details"). How can I write this expression, I searched, but did not find anything other than mentioning IIF expressions, but I am new to SSRS and do not know how to write them upside down. Sorry if he was given an answer, I just could not find him.

This is how I have an expression for the visibility table of my detail to show if the Summary parameter is false (I also found this on the Internet):

=IIF(Parameters!IsSummary.Value = 1, True,False) 
+7
source share
2 answers

I believe that you have gained a reputation for choosing an answer (I also put your question on a turn-key basis)

 =IIF(Parameters!IsSummary.Value = 1, "Report (Summary)", "Report (Detail)") 

The basic structure of Iif:

 Iif(<equality>,<do this when true>, <do this when not true>) 
+6
source

it is more compact beacuse if is boolean, you do not need equivalence.

 =IIF(Parameters!IsSummary.Value, "Report (Summary)", "Report (Detail)") 
+2
source

All Articles