Author Topic: Using Switch Case in SSRS  (Read 14987 times)

amithalari

  • Newbie
  • *
  • Posts: 4
    • View Profile
Using Switch Case in SSRS
« on: September 15, 2012, 11:48:31 AM »
=switch(Parameters!Type.Value="-1","All"
      ,Parameters!Type.Value="1","Ahmedabad"
      ,Parameters!Type.Value="2","baroda"
      ,Parameters!Type.Value="3","Surat")

Ritesh Shah

  • Administrator
  • Jr. Member
  • *****
  • Posts: 57
  • Ritesh Shah
    • View Profile
    • IT Technology Blog
Re: Using Switch Case in SSRS
« Reply #1 on: September 15, 2012, 12:09:55 PM »
This is good one, Amit....
Ritesh Shah
Administrator
Extreme-Advice.com
SQLHub.com