none
IIF Statement to toggle the "All" parameters to "All Lines of Business"

    Question

  • I am attemptting to toggle a parameter in a list.  IF it says "All" I want to display "All lines of Business" instead.

    How can I get the IIF statement set up?

     ="New Business " & Parameters!lob_id.Label & vbcrlf & " Policy Count Detail"
    • Edited by soldierfc Thursday, January 23, 2014 8:42 PM
    Thursday, January 23, 2014 8:39 PM

Answers

  • I guess I've figured it out myself:

    =IIF(Parameters!lob_id.Label = "All","All Lines of Business",Parameters!lob_id.Label) & " Policy Count Detail"

    • Marked as answer by soldierfc Thursday, January 23, 2014 9:59 PM
    Thursday, January 23, 2014 9:59 PM

All replies

  • I keep getting #error for the expression:

    IIf(Parameters!lob_id.Label, "All","All Lines of Business") & vbcrlf &

    Thursday, January 23, 2014 9:32 PM
  • I guess I've figured it out myself:

    =IIF(Parameters!lob_id.Label = "All","All Lines of Business",Parameters!lob_id.Label) & " Policy Count Detail"

    • Marked as answer by soldierfc Thursday, January 23, 2014 9:59 PM
    Thursday, January 23, 2014 9:59 PM