Home Forums Reporting Services Reporting Services Text based on parameters RE: Text based on parameters

  • December 27, 2014 at 3:32 am

    #1766545

    That's Correct..but still you can use IIF to solve problem

    =IIF(Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "ext" , "Phone List",

    IIF(Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "cell" , "Cell Phone List",

    IIF(Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "email" , "Cell Email List"

    )))

    Thanks,

    Dhana.!