SSRS Use IIF or Switch?

• Gillian_Pappas2002

  SSCommitted

  Points: 1714

  More actions

  January 13, 2014 at 11:12 am

  #288319

  Hi. Hope everyone had a great weekend. I am new to SSRS and need to probably use IIF or Switch statement.

  I've attached my SSRS Design. I want to check my input parameter and change the 1st column/field based on the value of that input parameter. If the input parameter < 1 I want the first field to return Room values else I want the first field value to return pattern values.

  Thanks very much.

  G

• Michael_Garrison

  Hall of Fame

  Points: 3110

  More actions

  January 14, 2014 at 6:52 am

  #1679874

  Looks like IIF might be fine for you. Can't really tell from your description and view. Read IIF in this link and see if this does not help you in your decision. http://msdn.microsoft.com/en-us/library/ms157328.aspx

• Gillian_Pappas2002

  SSCommitted

  Points: 1714

  More actions

  January 14, 2014 at 4:56 pm

  #1680098

  Thanks for your help. I did see that before. And I just can't quite find out how to make it work because it also affects my grouping. I bought a book on SSRS/Bids for SharePoint, but that didn't help much either. What I need is a super, duper book that shows me how to construct different groupings and all of the different commands I can use in SSRS and Bids.

  Thanks and have an awesome night.

  G

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  January 14, 2014 at 5:39 pm

  #1680105

  Depending on your exact requirements (I haven't looked at your Word document, I don't trust them - sorry) you might consider having one table for each option and just change the "visibility" of each depending on the parameter value - it can sometimes be easier than having lots of complicated expressions using IIF

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]